I could massage the sql date format in my select statement, but I am trying to keep my select statements as simple as I can, so I have 2 functions that convert to and from the standard sql date format.
Bob On Jan 11, 2012, at 5:55 PM, Warren Samples wrote: > On 01/11/2012 07:20 PM, Bob Sneidar wrote: >> 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 > > Is the problem getting them from Livecode to mySQL or what mySQL returns from > select? > > Can you set the date format in your select statement? > > http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format > > Warren > > _______________________________________________ > 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