php/mysql datestamps

frieza · 09-16-2008, 12:23 PM

i have a database program that inserts datestamps into a database
they look in the database like

Code:

1219782825

how do i read that with my own php script as a date/time instead of the raw date stamp?

Four · 09-16-2008, 01:04 PM

I don't know what that number represents; For a MySQL like database the tutorial describes the date datatype.

By looking at the number and trying "semirandom" stuff; perhaps to get the year in php

$year = floor(1970 + $stamp/(60*60*365*24))
$day = floor(365.0*(1970 + $stamp/(60*60*365*24) - $year))
$hour = floor( ((365.0*(1970 + $stamp/(60*60*365*24) - $year)) - $day)*24.0)

I guess you can go from there to figure out the minutes & seconds.

jchambers · 09-16-2008, 01:05 PM

I do the following but you can use date in php as well.

`date_added` timestamp NOT NULL default CURRENT_TIMESTAMP

Code:

	<?
	list($date) = explode(' ', $row['date_added']);
	echo $date;  // 2008-09-15
	?>

Take a look at this link as well.
http://us3.php.net/date

Jon

graemef · 09-16-2008, 04:07 PM

The PHP function date will accept two arguments, the first is a format string, the second is a timestamp.