MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > equivalent date of the "dateline" in PHP MyAdmin SQL
Full Version: equivalent date of the "dateline" in PHP MyAdmin SQL
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

KANTUTAN

2014-04-16, 08:35 PM
I really don't get this http://community.mybb.com/thread-68577-p...#pid494870

How did he convert this?

`dateline` BETWEEN '1235541600' AND '1267077600';

from

25-02-2010 to 25-02-2009

??

pavemen

2014-04-16, 08:38 PM
http://www.w3resource.com/mysql/date-and...nction.php

KANTUTAN

2014-04-16, 08:46 PM
sir, could you please give me an easiest way to compute?
is http://www.w3resource.com/mysql/php-scri...nction.php our current dateline?
UNIX TIMESTAMP in seconds :

UNIX TIMESTAMP in seconds
1397681320
how about the UNIX TIMESTAMP in second in year 2012? how to compute that?

any formula?

regards,

KANTUTAN

Destroy666

2014-04-16, 10:07 PM
http://www.onlineconversion.com/unix_time.htm

You can convert from and to UNIX time there.

KANTUTAN

2014-04-16, 10:15 PM
Rep added to both of you

regards,

KANTUTAN
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > equivalent date of the "dateline" in PHP MyAdmin SQL