Display Date and Time format

[Drewww]

For those that poke about in the database and want to find out what date and time format looks like for some entries like when a player has logged out. The database for dbo.RoleData_Account field for LogoutTime shows a long number like 1438362717
That can be converted to a readable string we can understand with this game macro:

/script DEFAULT_CHAT_FRAME:AddMessage(os.date("%c",1438362717))

This will print to a client chat box:
2015-08-01 17:11:57

 

[Turmalin]

Or using any unix timestamp <-> date converter(

You must be registered to see links

, for ex.)