SQL Date Formatting

Bob Sneidar bobs at twft.com
Wed Jan 11 21:32:32 EST 2012


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 <bobs at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list