Convert date

Bob Sneidar bobsneidar at
Thu Jul 13 11:22:50 EDT 2023

I wrote a formatDate function years ago that called this "sql date". Maybe I should rename it “ISO Date” or just add a case for it. There is also an “sql time” format in the function formatTime. This way you can put format date(the date, “sql date”) && formative(the time, “sql time”) to get an sql datetime format for a database column. They should be in the Master Library.

I suppose a lot of things could be done by the engine, but as was discussed years ago, what LC is NOT is a development environment that does almost anything. What it IS is a development environment that has the TOOLS to do almost anything.

Bob S

On Jul 13, 2023, at 1:19 AM, Neville Smythe via use-livecode <use-livecode at> wrote:

I seem to have hallucinated that the built-in convert handler recognised the ISO date and dateTime formats (YYYY-MM-DD, YYYY-MM-DD, etc) but I must have written my own conversion routines in a former life.

But one would have to ask… Why doesn’t it? After all, the original ISO 8601 standard was adopted 1988!

Neville Smythe

More information about the use-livecode mailing list