Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Miscellaneous => Topic started by: Big Bad Bot on March 10, 2016, 11:33:12 pm

Title: Timestamp in SQL?
Post by: Big Bad Bot on March 10, 2016, 11:33:12 pm

Hello there. In the SQL of the WLK server, all the dates are expressed with numbers like this one:

1459872570

How can I see wich time actually is?

Title: Re: Timestamp in SQL?
Post by: schlumpf on March 10, 2016, 11:49:18 pm

Unix timestamp converter

Title: Re: Timestamp in SQL?
Post by: Amaroth on March 11, 2016, 09:54:03 am

Its number of seconds passed since since Jan 01 1970. Like schlumpf said, you can google up a simple converter.

Title: Re: Timestamp in SQL?
Post by: barncastle on March 11, 2016, 09:56:12 am

In Mysql you can use FROM_UNIXTIME i.e. SELECT FROM_UNIXTIME(1459872570)

Title: Re: Timestamp in SQL?
Post by: Amaroth on March 11, 2016, 10:47:55 am

Wow, I didn't know about this, big thanks barncastle!