Hi Seano,
Dates are a pain. What locale is your server set to? Are you using setLocale() anywhere?
But your problem is that "1/3/80" is not a date and CreateODBCDate(date) expects a date object as it's parameter. If you give it a string then it will do it's best to evaluate the string to a date and will then convert that to an ODBC date. The problem is in the string to date conversion, not in the way mySQL is storing it.
If you want to be sure of what is going to the database then extract the day, month and year from your string, use createDate(year, month, day) to create your date and pass the result to CreateODBCDate(date).
Brett B)
Seano wrote:
Sorry for most likely an obvious one..but...
How do I store a date entry without CreateODBCDate() turning into USA format?
Have no trouble with now() but I would like just to store "1/3/80" as a date. CreateODBCDate() sends {d 3/1/80} and MySQL stores it as such.
Thanks v much
Sean
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
-- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au
--- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
