Example 1: sql server cast date dd/mm/yyyy -- string to date SELECT cast ( convert ( date , ' 23 / 07 / 2009 ' , 103 ) AS DATE ) select convert ( date , ' 23 / 07 / 2009 ' , 103 ) Example 2: SQL query to convert DD/MM/YYYY to YYYY-MM-DD SELECT CONVERT ( varchar ( 10 ) , CONVERT ( date , ' 13 / 12 / 2016 ' , 103 ) , 120 ) Example 3: 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 ) : SELE