Formatting date to store in MySQL table

[emartin24]

Hello,

 

I have a date that's in DATE_RFC822 format: Thu, 31 May 2007 18:16:55 EDT

 

I want to store it in a MySQL table as a TIMESTAMP. When I try to do a strtotime on the value and insert it, I get an 'Incorrect datetime value' error for the column.

 

I also would like to have it be a PST value, but I guess I can just convert it when I retrieve it from the DB.

 

Any suggestions?

[Caesar]

What you making the column? INT? DATE? Just make the column INT...and strtotime() it.

[Caesar]

I just tested your formatted date string on my Linux server..works fine.

 

<?php

$str = strtotime('Thu, 31 May 2007 18:16:55 EDT');
$newtime = date("M d, Y", $str);

print($newtime);
print($str);

/* Returns:

May 31, 2007
1180649815
*/
?>

[Caesar]

I also would like to have it be a PST value, but I guess I can just convert it when I retrieve it from the DB.

 

Yes...format it only after you retrieve it. It's best to store it as a pure timestamp.

[emartin24]

What you making the column? INT? DATE? Just make the column INT...and strtotime() it.

 

I was trying it with DATE, TIMESTAMP, etc., but changing it to INT is what I needed

 

Thanks!