LiveCode Forums.

Hello

I want to store dates in an SQL database. A way to do it seems to be (for today's date): and then to store the integer tDateAsSeconds in the database. My questions are:
1) When I add the line then the output is empty (and not the integer coding the date). Why?
2) Please provide code to convert the tDateAsSeconds (for instance: after retrieving it back from the database) back to a date and to display it in a readable format via 3) Is there a way to store the date in a more consistent way - i.e. as days, not as seconds
4) If you know any other ways to store the date in a database, please share them

Thanks in advance
greg falda

Hi Greg,

do this:

Best

Klaus

See the dateItems option for the convert command.

You could use CONVERT() function in you SELECT query when you get the data from the database
ex. "SELECT CONVERT(VARCHAR(24),theDate,113) FROM myTable" Where theDate is the column name.
Assuming your date is stored in seconds in your database this would return the date in dd mon yyyy hh:mi:ss:mmm.

Wondering why you are not using the standard sql date format of YYYY-MM-DD?

Thanks to all for your help.

You helped me to solve my problem

Best
greg falda