This is a read only copy without any forum functionality of the old Modcraft forum.
If there is anything that you would like to have removed, message me on Discord via Kaev#5208.
Big thanks to Alastor for making this copy!
Home
Forum
Modcraft - The community dedicated to quality WoW modding!
Forum
Wrath of the Lich King Modding
Miscellaneous
Timestamp in SQL?
Menu
Discord
Tutorials
Links
WowDev wiki
Print
Pages: [
1
]
Author
Topic: Timestamp in SQL? (Read 924 times)
Big Bad Bot
Registred Member
Polygonshifter
Posts: 75
Timestamp in SQL?
«
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?
«
Last Edit: January 01, 1970, 01:00:00 am by Admin
»
Logged
schlumpf
Administrator
Creator of Worlds
Posts: 2967
Re: Timestamp in SQL?
«
Reply #1 on:
March 10, 2016, 11:49:18 pm »
Unix timestamp converter
«
Last Edit: January 01, 1970, 01:00:00 am by Admin
»
Logged
Amaroth
Contributors
Creator of Worlds
Posts: 1219
Re: Timestamp in SQL?
«
Reply #2 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.
«
Last Edit: January 01, 1970, 01:00:00 am by Admin
»
Logged
English YT tutorial channel. Check it out if you preffer videos over walls of text.:
https://www.youtube.com/AmarothEng
Want to support me for my releases and/or tutorials? You can send donation via Paypal to:
jantoms@seznam.cz
barncastle
Registred Member
GM Isle Explorer
Posts: 21
Re: Timestamp in SQL?
«
Reply #3 on:
March 11, 2016, 09:56:12 am »
In Mysql you can use FROM_UNIXTIME i.e. SELECT FROM_UNIXTIME(1459872570)
«
Last Edit: January 01, 1970, 01:00:00 am by Admin
»
Logged
Amaroth
Contributors
Creator of Worlds
Posts: 1219
Re: Timestamp in SQL?
«
Reply #4 on:
March 11, 2016, 10:47:55 am »
Wow, I didn't know about this, big thanks barncastle!
«
Last Edit: January 01, 1970, 01:00:00 am by Admin
»
Logged
English YT tutorial channel. Check it out if you preffer videos over walls of text.:
https://www.youtube.com/AmarothEng
Want to support me for my releases and/or tutorials? You can send donation via Paypal to:
jantoms@seznam.cz
Print
Pages: [
1
]
Modcraft - The community dedicated to quality WoW modding!
Forum
Wrath of the Lich King Modding
Miscellaneous
Timestamp in SQL?