25 Jul
2012
25 Jul
'12
4:30 a.m.
Dear all,
How to use DATE_FORMAT on query with zdb?
I have a query which use DATE_FORMAT( DATE_START, '%d-%m-%Y %k:%i:%s' ) AS DATE_START The return from ResultSet_getStringByName( r, "DATE_START" ) is -1208391138-Success-2012 16:0:(null)
The data on table is 2012-04-19 16:04:00 so the result should be 19-04-2012 16:04:00
Please help me, Thanks