Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

interesting numbers

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

interesting numbers

Postby mazius123 » Wed Feb 09, 2011 2:50 pm

hello , in my mysql was line in witch my web writes time in not understanding numbers .
for example : 1297291166 or 1297297314 , so how to understand there is secounds , where is minutes and where is hours ? please say m i am noob on php and mysql :help:
mazius123
New php-forum User
New php-forum User
 
Posts: 2
Joined: Mon Feb 07, 2011 3:46 pm

Re: interesting numbers

Postby mazius123 » Thu Feb 10, 2011 5:53 am

anyone? :help:
mazius123
New php-forum User
New php-forum User
 
Posts: 2
Joined: Mon Feb 07, 2011 3:46 pm

Re: interesting numbers

Postby egami » Thu Feb 17, 2011 12:03 pm

This is seconds since Jan 1, 12:01:01 1970.

So, if you want to know how many minutes it would be..

time / 60;

Hours would be

(time / 60) / 60;

and so forth.

If this doesn't make sense, let me know.

But you can calculate the time pretty easily.. or make php do it for you..

date('m/d/Y G:i',$row['fieldname'])
User avatar
egami
php-forum GURU
php-forum GURU
 
Posts: 2196
Joined: Wed Oct 06, 2010 11:19 am
Location: Happy Valley, UT


Return to phpMyAdmin

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.