problem with csv file date column

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
B.Murali Krishna
Forum Commoner
Posts: 28
Joined: Fri May 12, 2006 2:05 am
Location: Hyderabad,India
Contact:

problem with csv file date column

Post 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
User avatar
dude81
Forum Regular
Posts: 509
Joined: Mon Aug 29, 2005 6:26 am
Location: Pearls City

Post by dude81 »

This happens when you open csv file through MS-excel, try to open it through a notepad. It will not change
chrisranjana
Forum Newbie
Posts: 12
Joined: Sat Jun 03, 2006 4:42 am
Location: chennai India
Contact:

mysql date time functions

Post by chrisranjana »

Or did you want to use these mysql date time functions to display the date according to your desired format ?
Post Reply