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
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