timestamps, mysql and php

[neilmurray]

Hi,
I have a mysql database with a persons login date and time as a field and I have designated it as timestamp. I then want to get this info and plot it on a graph. I call for it from the database and it comes in this format.
200506210000000 which is 2005 june 21st 00:00:00. I have tried loads of different ways of now getting the php to see this as a date but am having no joy. Really what I want is to see it as a date and as seconds elapsed from say Jan 1st. Can any one help?

Thanks,

Neil.

 

[sleipnir214]

PHP's strtotime() will likely not like the time portion of that string.

Have you tried typecasting the value inside MySQL? Something like

SELECT cast (timstampcolumnname as DATETIME) as foo from tablename


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[neilmurray]

Thanks, I'll give it a go.

Neil.