sql server to_date
-- Oracle:TO_DATE(string, format)
SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual;
SELECT TO_DATE('05/06/2012 13:25:12', 'DD/MM/YYYY HH24:MI:SS') FROM dual;
-- SQL Server: CONVERT(data_type, string, style). Cf source link for style codes.
SELECT CONVERT(DATETIME, '2012-06-05', 102); -- Raises error if impossible
SELECT TRY_CONVERT(DATETIME, '2012-06-05', 102); -- Returns Null if impossible
-- MySQL: STR_TO_DATE(string, format):
SELECT STR_TO_DATE('2012-06-05','%Y-%m-%d');
Log in, to leave a comment
4.2
10
SELECT STR_TO_DATE('17-09-2010','%d-%m-%Y');
Thank you!
10
0
Are there any code examples left?
New code examples in category SQL
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Relative searches
date format in sql
date format yyyy-mm-dd in sql
sql date format
converto date sql
convert date 103 sql
convert yyyy-mm-dd to dd/MM/yyyy sql server
to date sql server
mysql convert date
date convert function in sql
sql insert date format yyyy-mm-dd hh:mm:ss
sql query format date mm/dd/yyyy
t sql convert date to string mm/dd/yyyy
convert date time to date in sql
convert datetime to ddmmyyyy in sql server
format date sql dd/mm/yyyy sql server
cast datetime to date in mysql
cast date in mysql
mysql convert datetime to date
t-sql format date to yyyy-mm-dd
convert dates in sql
sql where date how convert string to date
sql server format date dd/mm/yyyy hh mm
string to date in mysql
convert date parameters in sql
DATETIME to DATE with format in SQL
convert from datetime to date sql
dd/mm/yyyy format code in sql
dd-mm-yyyy format in sql
sql server mm/dd/yyyy format
sql server convert date to yyyymmddhhmmss
get date in dd/mm/yyyy format in sql
convert date to yyyy-mm-dd in sql
sql server cast datetime to date
date format dd MMM yyyy in sql server
from and to date in mysql
sql server date converto to yyyy-mm-dd
cast sql date format
SQL date format convert
sql select where yyyy-mm-dd
sql select yyyy-mm-dd
sql transform datetime to date
T-sql convert string to date
how to cast date with time in sql server to datetime
SQL convert a string to a date
t-sql date formats yyyy-mm-dd
convert string a datetime sql server
sql convert datetime to yyyymmddhhmmss
cast to date in format SQL
Convert a datetime SQL
convert datetime in date in sql
convert string in date sql
convert(varchar to datetime sql server yyyymmdd)
What's the string format to convert it to a date SQL
dd/MMM/yyyy in sql
cast getdate to yyyy-mm-dd sql
convert datetme in date sql
convert int yyyymmdd to date sql
convert string to sql time
sql where to_date
sql where date format dd/mm/yyyy
mysql to date
sql convert varchar to datetime format dd/mm/yyyy
cast string as datetime sql
convert datetime to date mysqlsql
in sql how to change a string to a date format
sql format dd/mm/yyyy
cast datetime to date mysql
sql text date string to date
sql where convert string to date dd-mm-yyyy
sql server convert date to dd-mmm-yyyy
format date sql server dd/mm/yyyy
select from date to date mysql
convert Sql date format
cast text to date in sql server
cast date time to date in sql
sql convert text to date
text to date in sql
convert date 112 format sql
format(,'MM-dd-yy hh:mm') sql
sql date conversion
convert date 103 in sql
varchar to date convert sql
Date from sql to date
sql server convert date dd/mm/yyyy
sql query for date in dd/mm/yy
sql convert dd/mm/yy to value
cast date format in sql
select sql date format dd-mmm-yyyy
sql convert mm-dd-yyyy
sql date format dd-mmm-yyyy
how to convert date in string sql
convert date to datetime in sql server
how to convert datetime to date in sql
convert string to datetime in sql
datetime format in sql dd-mmm-yyyy
how to convert string to date in sql server
display date in dd-mon-yyyy format in sql
date convert in sql
t-sql convert date
how to display date in dd-mm-yyyy format in sql
cast to datetime in sql
convert date from 'mm.dd.yyyy' sql*
convert date from mm.dd.yyyy to YYYY/mm/dd sql
str_to_date function sql
str to date function sql
convert date in yyyy-mm-dd format in sql server
sql convert string to time
convert date and time to date in sql
sql dd.mm.yyyy hh mm format
str_to_date parameters sql
sql date formats dd mmm yyyy
convert dd-mm-yyyy to datetime in sql server
sql date format mm.dd.yyyy
convert string datetime to datetime in sql server
convert date in yyyy-mm-dd format in sql
sql convert datetime to data
tsql convert string to date format
mm/dd/yyyy format in sql
how to convert string to date formate in sql.
sql format date dd/mm/yyyy
sql convert(datetime to date)
sql to_datetime
mysql datetime to date convertor
mysql datetime to date convert
datetime to mysql date
sql server date format yyy-MM-dd
sql to_date timestamp
convert date to dd-mmm-yyyy format in sql
sql server can't convert dd/mm/yyyy to yyyy-mm-dd
sql convert date yyyy-mm-dd
convert(date/time to date sql)
yyyy-mm-dd format in sql
how to format date in sql to dd/mm/yyyy
how to convert into datetime in sql server
dd/mm/yyyy sql server
tsql to_date
convert string field to datetime in sql server
sql convert timestamp to date dd/mm/yyyy
sql current date in yyyy-mm-dd format
convert mysql date to time
convert date in yyyy-mm-dd HH:MM:SS format in sql
sql convert from string date yymm
sql convert string date yymm
sql convert string date
convert varchar date 'yyyy-mm-dd' sql
sql date convert into yyyy-MM-dd
string to datetime sql
sql dateformate dd/mm/yyyy to yyyy-mm-dd
from date to date in sql
convert datetime to datetime sql server
t-sql convert datetime to string dd/mm/yyyy
convert date from string to datetime in sql
format date in sql server dd-mm-yyyy
format date in sql server yyyy-mm-dd
date sql convert format
dd/mm/yyyy in sql server 2012
sql convert string yyyymmdd to date dd/mm/yyyy
STR to date SQL
date from to mysql query
mysql datetime to date
convert date to varchar format yyyy-mmm-dd in sql server
convert date to varchar format in sql server
convert varchar to date format in sql server
convert varchar to date in sql server & format
convert date format sql
sql convert string into date format
sql date format convert dd mm yyyy to dd/mm/yyy
sql cast date to formatted string
using to_date in sql
sql to date format
convert string as date in sql server
sql date conversion format
sql date from to
cast string to date sql
sql server convert as date)
sql date today format yyyy-mm-dd
how to date from datetime in sql server
SQL MM/dd/yyyy format
convert datetime sql format
convert getdate result to datetime in sql server
convert getdate to datetime in sql server
change format of date from yyyy-m-d to yyyy-mm-dd using sql command
converting string to date in sql
sql convert date m/d/yyyy
how can i get date in yyyy mm dd format in sql server
cast datetime as date sql
MSSQL where DateTime yyyy-MM-dd yyyy.MM.dd
t-sql convert date format
sql server date format dd/mm/yyyy
to_date pl sql
sql convert date format dd/mm/yyyy to mm/dd/yy
how to use dd mm yyyy in sql server
convert string to date sql query
format datetime to date in sql
sql convert int to date yyyymmdd
sql server convert a string to datetime
convert from Date to sql.date
sql server convert yyyy-mm-dd string to date not working
sql server convert yyyy-mm-dd string to date
sql server convert mm/dd/yyyy string to date
sql server convert to datetime
sql convet to date time
mysql convert date time to date
format sql date yyyy-mm-dd alter table
sql conver string to date
sql server datetime format mm/dd/yyyy
convert string to date sql server mm/dd/yyyy
format sql date yyyy-mm-dd
sql convert date to yyyymmdd format
dd-MMM-yyyy in sql server
sql cast string to date
sql convert string ot date
sql server string to date CAST
sql server convert string to date CAST
sql server convert string to date
convert sql date to mm/dd/yyyy
sql datetime convert formats
convert to date format mysql
converting string to datetime in sql
how to convert the data to yyyy mm dd in sql
sql select date yyyy-mm-dd
SQL SERVER DATE FORMAT IN MM-dd-yyyy
SQL DATE FORMAT IN MM-dd-yyyy
t-sql convert datetime to date
convert string to datetime in a table in sql server
convert string to datetime sql server
convert to date sql server
convert string to date with dd-mm-yyyy format in sql
convert string to date in sql
date column convert to yyyymmdd in sql server
convert date time to sql date
sql datetime dd mmm yyyy
sql datetime dd mm yyyy
sql datetime dd mmm yyy
convert string to date mysql
sql string date to date
convert string to date in mysql
convert a datetime to date in sql
sql server date format dd-mmm-yyyy hh mm ss
how to convert date in varchar in sql
turn datetime into date sql
convert in sql server date format
sql varchar to date
convert datetime in sql
date to datetime mysql
datetime to date mysql
how to convert string to date in sql
convert datetime sql server
sql convert datetime 103
sql server datetime convert
convert date to dd/mm/yyyy sql
date time convert in sql server
cast date sql yyyymmdd
convert date mysql
varchar to date mysql
converting date in a query in mysql
converting date in a query in sql
convert into date in sql
sql date format from string
sql server convert date string to date
TO_DATE IN SQL QUERY
date dd mm yyyy sql
format date sql dd/mm/yyyy
sql datetime format mm/dd/yyyy
sql date format mm/dd/yyyy
sql format date mm-dd-yyyy
sql format date MM-DD-YY
sql server string to date
sql server date convert
date format conversion sql
sql datetime formats convert
convert date format in sql
sql format date dd-mmm-yyyy
convert datetime to date mysql
to-date in sql
convert from string to datetime in sql server
to date in mysql
to_date use in sql
how to convert date string to datetime in sql
sql convert as datetime
sql server date format yyyy-MM-ddThh:mm:ss
sql date format yyyy-MM-ddThh:mm:ss
sql convert varchar to date format dd/mm/yyyy
convert varchar to date in mmddyyyy format sql server
sql convert string to date yymmdd
CONVERT YY-MM-DD TO DATE SQL
str to date mysql
mysql str to date
convert(datetime sql
sql date to date
sql server date format dd-mmm-yyyy
convert datetime to date in sql query
sql server cast string to date
sql convert varchar date dd/mm/yyyy with time
sql CONVERT(VARCHAR date
sql change yyyy-mm-dd to MMM-YYYY
to date mysql
cast datetime to date using sql
to_char and to_date in sql server
sql string to datetime
convert datetime sql
sql convert date to string yyyy-mm-dd hh:mm
sql convert date to string yyyy-mm-dd
select convert string to date sql server
sqldate format dd/mm/yyyy
cast as date in sql
how to convert datetime to date in sql server
sql insert date format yyyy-mm-dd
sql to_date minutes
date in dd-mm-yyyy format in SQL
convert string to datetime in sql server
convert datetime to date in sql 103 format
convert to date in sql server
sql convert datetime to date
datetime to date sql server
date format sql mm/dd/yyyy
convert string to date sql server
dd-mmm-yyyy to date in sql server
string to date in sql
sql from datetime to date
string to date convert in sql server
sql cast VARCHAR to DATE
sql cast date as dd/mm/yyyy
cast date in sql
convert date in mysql
convert datetime to date sql
dd mm yy format in sql
convert dd mm yyyy to datetime in sql
sql format date mm/dd/yyyy
sql server convert datetime
sql convert string to datetime
sql cast date as yyyymmdd
cast To Date in sql
cast date to datetime sql server
cast string to datetime sql
get date in mm/dd/yyyy format in sql
sql turn datetime into date
convert string to date in sql server
convert format date sql
get date in format yyyy-mm-dd in sql
convert date time to date sql
yyyymmdd to date sql
FORMAT DATE T-SQL DD/MM/YYYY
string to date conversion in sql
sql server datetime to date
mysql convert to date
datetime to date in mysql
sql string as date
convert varchar dd/mm/yyyy to date in sql server
convert varchar to date in sql
sql convert date to yyyymmdd
sql convert string to date dd/mm/yyyy
cast date sql
convert datetime in sql to yyyymmdd
convert string to datetime sql
SQL CONVERT STRING IN DATE
cast format date sql
format datetime sql server yyyy-mm-dd
convert string YYYYMMDDHHMMSS in timestamp sql
date type format for convert function in sql
CAST DATE SQLSERVER DD/MM/YYYY
CAST STRING DD/MM/YYYY TO DATE SQLSERVER
sql convert integer yyyymmdd to date
convert varchar to date sql server dd/mm/yyyy
cast datetime to date in sql
Date in mm/dd/yyyy in sql server
sql to_date format
mysql datetime to date
cast getdate to date sql sql server
cast getdate to date sql
try convert date dd mm yyyy sql server
convert string to date sql server dd/mm/yyyy
string to sql date
convert date to sql
display date as YYYY/ MM in SQL
sql display date as yyyy-mm
Sql display date as MM/DD/YYYY
sql date formats yyyy/mm/dd hh:mm:ss
sql date formats yyyy/mm/dd hh:mm
datetime to date sql
sql convert string to datetime format
sql date time to date
parse date to sql format
oracle sql to_date
sql convert date to mm dd yyyy
sql date format yyyy-mm-dd in java
sql server date format dd-mm-yyyy
convert yyyymmdd en date sql
to date function in sql
date format yyyy-mm-dd sql server
sql convert date format
convert date sql server
string to date mysql
convert string into date in sql
convert function in sql for date format
mssql convert string to date yyyymmdd
sql string to dateimte
convert date string to datetime sql
sql convert date to 103
convert datatime to date sql server
sql getdate dd mm yyyy format
display date in yyyy-mm-dd format in sql
ms sql server cast datetime to date
convert date sql server dd/mm/yyyy
to_date sql date julien
sql server date format yyyy-mm-dd
sql cast datetime string to date
sql cast date format
sql cast date string to date
sql cast date string to datetime
convert string to date sql
sql convert to date time
WHAT RETURNS TO_DATE SQL
date from date to sql
convert date to sql date
sql server to_date()
date to datetime sql
convert(varchar to date in sql)
how to use to_date in sql where
how to use to_date in sql
how to convert string to datetime in sql server
date format dd-mmm-yyyy in sql
convert string to sysdatetime sql
format string to datetime sql
cast to date sql
convert datetime to date sql server
convert date format in sql 103
how to get date from sql to yyyy-mm-dd format
sql What function would you use to convert string value into date ?
convert datetime format in sql
CONVERT DATE TO DAY SQL SERVER
CONVERT DATE TO DAY SQL
sql convert date mm/dd/yyyy
sql datetime format mm/dd/yyyy hh mm ss
date convert sql
sql DATE to datetime
sql convert datetime
sql date format dd/mm/yyyy
sql server convert string to datetime
SQL CONVERT DATE
datetime to date in sql
sql datetime dd/mm/yyyy
sql datetime format dd/mm/yy
sql datetime format dd/mm/yyyy
dd/mm/yy h:mm date format sql
convert date sql server yyyy mm dd
dd/mm/yyyy hh:mm sql
convert datetime sql server dd/mm/yyyy only date
SQL TO_date for dd-MM-yyyy hh:mm format
to_date() sql
date format mysql yyyy-mm-dd
transform a string to a sql date
sql convert datetime to yyyymmdd
datetime to date in sql server
sql server convert datetime to date
mssql convert date to yyyy-MM-dd
convert nvarchar to date mm/dd/yyyy in sql
convert to date mysql
cast to date sql server
convert sql date to yyyymmdd
convert datetime to date in sql server
sql datetime yyyy-mm-dd
mssql date format yyyy-mm-dd
sql server date dd-mm-yyyy
sql format date dd-mm-yyyy
how to convert date format to yyyy mm dd in sql server
how to convert date format to yyyymmdd in sql
mysql string to date
to date sql
sql datetime to date
to_date format sql
convert to datetime in sql
to_date sql date and time
date to sql date
COnverting string to date sql;
convert to datetime sql
sql Turn string to date
sql cast datetime to date
sql convert to date
sql string to date
sql str_to_date with time
sql str_to_datetime
sql str_to_date datetime
convert to date sql
to date in sql
convert date in sql
convert date from string to date in sql
string to date sql
string to date sql server
sql date convert
convert datetime to date in sql
convert date sql
sql convert string to date format
sql convert string to date mm/dd/yyyy
sql convert string to date yyyymmddhhmmss
sql convert string to date yyyymmdd
sql server to date
sql server to_date
sql date format yyyy-mm-dd
sql convert string to date
mysql to date
sql to date
sql TO_TIME
to_date in sql server
to_date ms sql
to_date sql server
str_to_date in sql server
to_date sql syntaxe
sql to_date function
to_date in sql
to_sql date format
to_date oracle sql
to_date function in sql
SQL STR_TO_DATE
to_date sql
sql convert to_date
sql to_date
STR_TO_DATE mysql
w3schools str_to_date sql
str_to_date sql server
mysql text to date
mysql convert string to date
mysql convert date string to date
sql equivalent str_date
mysql time_date funciton
str_to_date sql
to_date mysql
string to date mysql format