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