interesting numbers

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

Moderators: macek, egami, gesf

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

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:

User avatar
egami
php-forum GURU
php-forum GURU
Posts: 2196
Joined: Wed Oct 06, 2010 11:19 am
Location: Happy Valley, UT

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'])


Return to “phpMyAdmin”

Who is online

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