Times in phpMyAdmin....

[The Ace]

I have no idea what time I did something, or something happened, because I can't read it. What time is this: 1206567629 and how do I tell all the other times of events, etc?

[Guest Anonymous]

Re: Times in phpMyAdmin....

2008/03/26 21:40:29

[The Ace]

Re: Times in phpMyAdmin....

Nyna, how did you work it out?

And thanks LostOne...will check it out now! :)

[Guest Anonymous]

Re: Times in phpMyAdmin....

 

echo date('Y/m/d H:i:s', 1206567629);

 

Simple really!

[The Ace]

Re: Times in phpMyAdmin....

Where'dya put this:

echo date('Y/m/d H:i:s', 1206567629);

[Guest Anonymous]

Re: Times in phpMyAdmin....

Methinks you may need to read PHP 101....

I ran that at the command line on a unix box

[[email protected] ~]$ php -r "echo date('Y/m/d H:i:s', 1206567629);"

2008/03/26 21:40:29

However you could just as easily create a simple php script

<?php echo date('Y/m/d H:i:s', 1206567629); ?>

and open it in a browser...

[The Ace]

Re: Times in phpMyAdmin....

Thanks....

Just Googleing PHP 101 now....gonna read up on it. Cheers.

[Tonka]

Re: Times in phpMyAdmin....

this is called unix time, all you need is a simple converter, i use either http://www.unixtimestamp.com/ or http://www.onlineconversion.com/unix_time.htm