AW: Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy' ) ? sql

Hi Marcos, you can use simple string-functions to manage this. For example: dd/mm/ -> -mm-dd CONCAT_WS('-',RIGHT('dd/mm/',4),SUBSTRING('dd/mm/',4,2),LEFT('dd/mm/',2)) CONCAT_WS(separator, string_1 ,string_2 ...)puts strings together with separato RIGTH(string,N)

Re: Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy') ?

]>20/06/2003 05:36 PM To: [EMAIL PROTECTED] cc: (bcc: BORNAY Richard/Engr/STATS/ST Group) Subject: Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/') ? Hi everybody, Is there any function like Oracle TO_DATE in order to insert a date into a

Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy') ?

Hi everybody, Is there any function like Oracle TO_DATE in order to insert a date into a DATE type field according to a different format than -mm-dd? I wish to insert a date into a date field but my date format is "dd/mm/". If not, is there any workaround using mysql functions? AFAIK my