Writing to a table with a datetime format

[mellenburg]

I have a variable in a table that has a date time format (0000-00-00 00:00:00). In PHP, I have calculated a date time constant (number of seconds from...). I would like to write that value to the table in the yyyy-mm-dd hh:mm:ss format. How do I do this? Thank you for any help provided.

 

[sleipnir214]

Use PHP's date() function to convert the CUE timestamp to a string MySQL will accept.

Something like

$datetimestring = date ('Y-m-d H:i:s', $timestampvariable);

http://www.php.net/manual/en/function.date.php

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!