Page 1 of 1

STR_TO_DATE()

Posted: Fri Jun 06, 2008 10:10 am
by bouncer
hi there.

how can i change my date formate using STR_TO_DATE function to AAAA-MM-DDThh:mm:ss, my code is

[sql] registry_date = STR_TO_DATE(@datafield1, '%d-%m-%Y') [/sql]

thanks in advance