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!

Menu
Pages: [1]

Author Topic: Timestamp in SQL?  (Read 919 times)

Big Bad Bot

  • Registred Member
  • Polygonshifter
  • *****
  • Posts: 75
    • View Profile
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
    • View Profile
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
    • View Profile
    • Amaroth's Tools
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
    • View Profile
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
    • View Profile
    • Amaroth's Tools
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
Pages: [1]