sql 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');

View another examples Add Own solution

Log in, to leave a comment

4.38

8

3cheesewheel 90 points

                                    Example 
SELECT CONVERT(varchar, '2017-08-25', 101);

CONVERT(data_type(length), expression, style)

Converting datetime to character:
Without century	With century	Input/Output	Standard
0	100	mon dd yyyy hh:miAM/PM	Default
1	101	mm/dd/yyyy	US
2	102	 yyyy.mm.dd	ANSI
3	103	 dd/mm/yyyy	British/French
4	104	dd.mm.yyyy	German
5	105	 dd-mm-yyyy	Italian
6	106	dd mon yyyy	-
7	107	Mon dd, yyyy	-
8	108	hh:mm:ss	-
9	109	mon dd yyyy hh:mi:ss:mmmAM (or PM)	Default + millisec
10	110	mm-dd-yyyy	USA
11	111	 yyyy/mm/dd	Japan
12	112	 yyyymmdd	ISO
13	113	dd mon yyyy hh:mi:ss:mmm	Europe (24 hour clock)&gt;
14	114	hh:mi:ss:mmm	24 hour clock
20	120	yyyy-mm-dd hh:mi:ss	ODBC canonical (24 hour clock)
21	121	yyyy-mm-dd hh:mi:ss.mmm	ODBC canonical (24 hour clock)
 	126	yyyy-mm-ddThh:mi:ss.mmm	ISO8601
 	127	yyyy-mm-ddThh:mi:ss.mmmZ	ISO8601 (with time zone Z)
 	130	dd mon yyyy hh:mi:ss:mmmAM	Hijiri
 	131	dd/mm/yy hh:mi:ss:mmmAM	Hijiri

Thank you! 8

4.38 (8 Votes)

0

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

dat format in sql mm/dd/yyyy sql format format date sql 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 cast date sql 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 convert Wed Aug date to date sql try convert date sql sql where date how convert string to date sql server format date dd/mm/yyyy hh mm sql server cast string to date 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 convert date time to varchar in sql date format dd MMM yyyy in sql server convert date in varchar 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 str_to_date sql server convert to date in sql server sql text date string to date sql where convert string to date dd-mm-yyyy sql server convert date to dd-mmm-yyyy cast varchar to datetime sql 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 cast string to date 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 t-sql convert date 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 DateTime to VarChar in sql 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 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 t-sql datetime convert 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 str_to_date SQL 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 data convert sql 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 data convert sql date from to cast string to date sql sql server convert as date) sql date today format yyyy-mm-dd convert data sql 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 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 convert string to date sql 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 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 convert varchar to datetime 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 string to date with dd-mm-yyyy format 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 cast as date in sql sql convert date to time date time convert in sql server cast date sql yyyymmdd convert date mysql cast date and time in sql 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 convert varchar date to datetime in sql 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 sql STR_TO_DATE str_to_date in sql server date conversion in sql date format conversion sql sql datetime formats convert convert datetime to varchar 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 convert Time to Date 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 converting varcahar to date time sql convert string to date yymmdd CONVERT YY-MM-DD TO DATE SQL cast datetime sql str to date mysql mysql str to date sql cast date as datetime convert(datetime sql sql date to date sql server date format dd-mmm-yyyy convert datetime to date in sql query 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 date convert in ms sql sql string to datetime 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 how to convert datetime to date in sql server how to convert datetime 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 datetime to date sql server date format sql mm/dd/yyyy dd-mmm-yyyy to date in sql server string to date in sql sql from datetime to date cast date as datetime sql string to date convert in sql server converting date time to date in sql sql cast VARCHAR to DATE sql cast date as dd/mm/yyyy cast date in sql convert date in mysql dd mm yy format in sql how can I convert datetimes 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 sql standard convert 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 sql convert date to yyyymmdd sql convert string to date dd/mm/yyyy SQL CONVERT STRING IN DATE sql cast date to 103 convert string to date sql\ convert varchar to datetime in sql server datetime convert in sql server convert datetime in sql to yyyymmdd cast format date sql SQL convert datetime to date format datetime sql server yyyy-mm-dd sql cast as date mssql convert date convert string YYYYMMDDHHMMSS in timestamp sql sql how to convert varchar to date year date type format for convert function in sql CAST DATE SQLSERVER DD/MM/YYYY convert time sql CAST STRING DD/MM/YYYY TO DATE SQLSERVER to_date function in sql sql convert integer yyyymmdd to date convert varchar to date sql server dd/mm/yyyy cast datetime to date in sql mysql convert string to date 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 cast string date to date sql CONVERT DATE SQL 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 convert string to date in sql convert date to varchar in sql 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 convert varchar data type to date in sql 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 convert from varchar to datetime sql sql date convert date format yyyy-mm-dd sql server cast datetime as date sql string to date mysql convert datetime in varchar sql server sqlserver convert date 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 how to cast date to datetime in sql 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 sql convert to date time WHAT RETURNS TO_DATE SQL date from date to sql select convert date in 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 convert varchar column to date in sql cast to date sql 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 105 sql convert date mm/dd/yyyy sql datetime format mm/dd/yyyy hh mm ss varchar convert date sql server date convert sql sql DATE to datetime sql convert datetime sql date format dd/mm/yyyy sql server convert string to datetime 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 to_date in 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 t sql convert datetime to date 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 to_date sql convert sql date to yyyymmdd sql datetime yyyy-mm-dd mssql date format yyyy-mm-dd sql server date dd-mm-yyyy sql format date dd-mm-yyyy sql server convert varchar to date how to convert date format to yyyy mm dd in sql server how to convert date format to yyyymmdd in sql sql cast date mysql string to date to date sql convert date code sql sql datetime to date convert datetime sql sql server convert string to date\ convert to datetime in sql date to sql date COnverting string to date sql; convert date format in sql convert to datetime sql sql server convert date time sql Turn string to date sql cast datetime to date sql convert to date convert date time +sql convert varchar to date in sql server convert date function in sql server convert datetime to date in sql convert date sql server convert datetime to date in sql server convert string to date sql server convert to date sql to date in sql convert date in sql convert date from string to date in sql convert string into date in sql string to date sql SQl server date convert 103 how to convert a date into time in sql string to date sql server convert varchar to datetime sql server sql server convert date SQL date conversions 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 mysql to date sql to_date sql convert dates time sql convert dates convert varchar to date in sql convert string to datetime sql convert datetime to date sql Convert a date SQL Server Convert to date SQL Server sql convert varchar to datetime sql to date convert datetime to date sql server sql convert date format SQL CONVERT STRING TO DATE sql string to date sql convert date

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example