0
Undo
Votes
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
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
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
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
- Page :
- 1
There are no replies made for this post yet.