Forum > Miscellaneous

Timestamp in SQL?

(1/1)

Big Bad Bot:
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?

schlumpf:
Unix timestamp converter

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

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

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

Navigation

[0] Message Index