SQL Date Formatting

william humphrey bill at bluewatermaritime.com
Thu Jan 12 07:26:22 EST 2012


I have to say something here. I struggled with date formats trying to make
them all YYYY-MM-DD and you are trying to do something different. I think
of the yyyy-mm-dd as "real" date. It is easily readable (as seconds aren't)
and sorts perfectly. It is not one of the defaults for system date on the
Mac though which does cause problems sometimes until you set it as a custom
format.



More information about the use-livecode mailing list