By rusasadmins on Friday, 25 October 2019
Replies 1
Likes 0
Views 476
Votes 0
I see the date column, but the date is 'formatted' as:
select dtstart from xxx_jevents_vevdetail

dtstart = 1566932400

How can I convert this via 'sql' (just for viewing only), to an actual date?

I have to run an update script from an external table, to update the descriptions of our events...my 'update table' as the date-time, and the event title,

thanks,
Laura
Hello,

It is stored in unix timestamp format. You can use:

https://database.guide/unix_timestamp-examples-mysql/

As part of your query

Many thanks
Tony
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post