ooooh... I get it. have SQL change the way IT looks at dates. Well that would work. Instead though I decided to bite the bullet and write two functions to convert to and from standard mySQL date format. Thanks for the info though I will probably use that elsewhere.
Bob On Jan 11, 2012, at 5:50 PM, Mike Bonner wrote: > Can't try it but I believe you can do something like > > select field1, field2, DATE_FORMAT(yourdatefield,"%m/%d/%Y" from .... > > On Wed, Jan 11, 2012 at 6:20 PM, Bob Sneidar <b...@twft.com> 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 >> _______________________________________________ >> 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 _______________________________________________ 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
