[SOLVED] Translating DATETIME into TIMESTAMP

[woolyg]

Hi all,

 

Safe in the knowledge that TIMESTAMP format is DATETIME's ugly older sister, if I have a DATETIME string (2007-10-25 02:42:52) that I need to switch to TIMESTAMP.

 

Maybe I'm into ugly old chicks, who knows.

Can anyone help?

 

Cheers,

WoolyG

 

[rajivgonsalves]

you can use the UNIX_TIMESTAMP function in mysql

 

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_unix-timestamp

[woolyg]

Is there a way to do it in PHP? I just need to run a quick function using TIMESTAMP as opposed to DATETIME..

[obsidian]

Is there a way to do it in PHP? I just need to run a quick function using TIMESTAMP as opposed to DATETIME..

 

I'm not positive I follow, but if you're simply trying to translate a DATETIME into a unix timestamp, just use strtotime():

<?php
$dt = '2007-10-04 00:00:00';
$ts = strtotime($dt);
if ($ts !== FALSE)
{
  // Success!
  echo "Timestamp = {$ts}";
}
?>

[woolyg]

Nice one, I'll get this going and try to achieve it.

 

Thanks for your help guys.

Woolyg