25 Jul
2012
25 Jul
'12
2:03 p.m.
On Jul 25, 2012, at 3:53 PM, Jan-Henrik Haukeland wrote:
You have two options, either use a prepared statement and set the date format as a string or provide the date-format in its own string format (%s) like so:
Sorry for the extra spam, but I just remembered that there is a third option in where you "escape" % by using %%.
ResultSet_T r = Connection_executeQuery(c, "select DATE_FORMAT( DATE_START, '%%d-%%m-%%Y %%k:%%i:%%s' ) AS DATE_START..") while (ResultSet_next(r))