STR_TO_DATE()
Posted: Fri Jun 06, 2008 10:10 am
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
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