SQL Date Formatting

[Bob Sneidar]

Hi all. I am having F-I-TZ working with dates in mySQL. I WANT to store the dates as real dates, but mySQL formats them as yyyy-mm-dd. Livecode does no such thing and nothing I know how to do can get Livecode to work with dates in this format AS dates. 

It's no good for my present purposes to work with other formats. I query SQL and then drop the data into a datagrid with no custom formatting, and that is just the way it has to be. What I need is to tell Livecode to sue SLQ date formatting. I have no real hope, but if someone knows of a way to do that, I would appreciate it. 

I think what is really needed is a feature request for one more date format for the convert command: convert myDate to sqlDate. <sigh>

Bob