Thanks Bob. Sounds very useful. How does one access (or locate) the master library?
Cheers, Mark Sent from my iPhone > On Jul 13, 2023, at 4:24 PM, Bob Sneidar via use-livecode > <use-livecode@lists.runrev.com> wrote: > > 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 _______________________________________________ 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