[Resolved] TimeStamp Decode

NZ_Kiwi

Hi,

My database has a time stamp in it for example "1097533829" how do i display this as the current date and time

id10t

mktime

NZ_Kiwi

Originally posted by id10t
mktime

Sorry I should of said I know it is was mktime function but how to i write it?

Weedpacket

It's not mktime, it's [man]date[/man].

NZ_Kiwi

Originally posted by Weedpacket
It's not mktime, it's [man]date[/man].

Yeah okay but I how do i write it?

sarahk

I think you were expected to read the docs for date and it would become clear...

given that's not going to happen try this

<?PHP
echo date('d m Y', '1097533829')
?>

NZ_Kiwi

Originally posted by sarahk
I think you were expected to read the docs for date and it would become clear...

given that's not going to happen try this
<?PHP
echo date('d m Y', '1097533829')
?>
[/B]

So...

 <?PHP 
echo date('d m Y', '$timestamp') 
?>

sarahk

Originally posted by NZ_Kiwi
So...
 <?PHP 
echo date('d m Y', '$timestamp') 
?> 
[/B]

You're letting the side down mate, have you tested it?

 <?PHP 
echo date('d m Y', $timestamp);
?>

ie, without the quotes.

Consider joining the NZ PHP User Group too...

phpug at phpug dot org dot nz

NZ_Kiwi

Originally posted by sarahk
You're letting the side down mate, have you tested it?
 <?PHP 
echo date('d m Y', $timestamp);
?> 
ie, without the quotes.

Consider joining the NZ PHP User Group too...

phpug at phpug dot org dot nz [/B]

It only shows the date "31 12 1969"

sarahk

I get

12 10 2004

NZ_Kiwi

Originally posted by sarahk
I get

12 10 2004

okay

<?php echo date ('d M Y', $row["timestamp"]); ?>