MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > SQL Date Format
Full Version: SQL Date Format
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Franx

2010-12-17, 05:08 PM
Hello, i got this date on sql table "1292604864", this is today, like 20 mins ago, so "17 December 2010 18:46". I have to replace with "16 March 2009 8:10 AM", can anyone help me?

Sajuuk

2010-12-17, 05:13 PM
You need to find out the UNIX Timestamp version of that date. Try googling it as I have no idea what it is.

Franx

2010-12-17, 05:16 PM
Found, thanks Wink

http://www.unixtimestamp.com/index.php
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > SQL Date Format