Convert date

[Mark Smith]

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