Contents - Index

DateToSQL (function)

DateToSQL(dDate) : string

The function is provided to enable a native macro Date to be converted to a string date format used in SQLite tables. 

dDate - A GSAK date variable to convert. This may be any macro created variable, database variable, or system variable

Example, show the currnet date in Sqlite date format (at the time of writing this help section the current date was 30th January, 2014):
 

$sqlToday = DateToSql($_Today)
msgok msg=$SqlToday

 


Also see the complimentary function SQLToDate()

Alpha List         Category List