Page 1 of 1

problem with csv file date column

Posted: Wed Jan 31, 2007 5:04 am
by B.Murali Krishna
Hello ,

I copied the database table into csv file, but the date format is changing from "y-m-d" to "m/d/y" , how can i get the date exactly as in database fields.

Please help me regarding.

Murali Krishna

PHP Programmer

Posted: Wed Jan 31, 2007 7:04 am
by dude81
This happens when you open csv file through MS-excel, try to open it through a notepad. It will not change

mysql date time functions

Posted: Wed Jan 31, 2007 9:39 am
by chrisranjana
Or did you want to use these mysql date time functions to display the date according to your desired format ?