Convert Date

[thestudent]

is it possible to convert :

Thurs, 26 March 2009 1:30:11 into 2009-03-26 1:30:11 (standard mysql datetime)


thanks

 

[user-7256]

I assume you're using PHP?

Use strtotime() to convert it to a Unix timestamp (number of seconds past Jan. 1, 1970, the "Unix Epoch") then use date() to put it into the form you want.

Refer to the PHP manual on these functions if you have questions on how to use them. Good luck!

 

[Eric]

Not sure what your mysql db is set up like, but why not try using MySQL itself

SELECT DATE_FORMAT(date, '%m/%d/%Y') AS formatted_date FROM table;

Where 'date' is the name of the column that contains the datetime/timestamp and of course 'table' being the name of the table you're pulling from.