Convert date

[Bob Sneidar]

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 lists.runrev.com> 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 hh:mm:ss+-hh.ss, 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