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@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 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
