human date to timestamp

[jjshell]

Hi,

I-ve got this date:

19.11.2008 09:00:16

Is it possible to turn it into a timestapm that I could store in a db?

Thanks in advance

Regards,

-jj.

[Stormrider]

http://uk3.php.net/manual/en/function.strtotime.php

or, you could use a regular expression. I don't entirely trust functions that say 'give me something and ill try and output something useful!' - I like it's behaviour to be well defined, so I know what I can expect given different inputs!

[r937]

19.11.2008 09:00:16

you could also pass that string directly into mysql and use its STR_TO_DATE function to make a valid DATETIME value, or use STR_TO_DATE nested inside the UNIX_TIMESTAMP function to turn it into a unix epoch integer

you did not really say whether you wanted to store a datetime value or a "timestamp" value (which many people interpret as being the unix epoch timestamp)

[Raju Gautam]

$date = '19.11.2008 09:00:16';
list($date, $time) = split(' ', $date);
list($d, $m, $y) = split('\.', $date);
$timestamp = strtotime("$y-$m-$d $time");
echo date('Y-m-d H:i:s', $timestamp);