SQL Date Formatting

[Bob Sneidar]

I think (I will be corrected if I am wrong) that it is a Canadian format. I don't think it is a mac specific problem. I went through all the date formats on the Mac OS and found that Canada is the only country listed that formats the dates this way. I also think it makes a lot more sense. 

Bob


On Jan 12, 2012, at 4:26 AM, william humphrey wrote:

> 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.
> _______________________________________________
> 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