DateFormat

[peterb1985]

I have a csv file that i'm trying to load into a mysql database, using a coldfusion page.

In the csv file the date is in the format dd/mm/yyyy but when i use #dateformat(string,"yyyy-mm-dd")# to store it in my database, if the date is at the begging of the month then it swaps the day and the month. For example:

03/08/2005 = #dateformat(string,"yyyy-mm-dd")# = 2005-03-08 instead of 2005-08-03

Is there a way to stop this?

 

[r937]

if you're using coldfusion instead of just loading the csv straight into mysql using a load utility, then why not use substring functions to assemble the pieces of the string into a format that coldfusion will recognize correctly

if you say #dateformat(string,"yyyy-mm-dd")# you are relying on coldfusion first to interpret the string correctly, and then display it in the specified format

it's not interpreting it correctly unless you help it

r937.com | rudy.ca

 

[pigsie]

I've seen this before on some platforms such as Ingres - what database/driver?

what happens if you create a datatiem object from the data using lsParse date or createODBCDate or something similar then try and format? Try setting the locale and using LsDateFormat