Skip to main content

Dates from Custom Fields

in Date and Time Operations
Authors list
Diterbitkan: 16 Mar 2017|Last updated: 3 Nov 2022

If you’re retrieving a date stored in a custom field, it is stored as an integer timestamp rather than real date types, so you need to pass it through the FROM_UNIXTIME function first, e.g.:

SELECT DATE_FORMAT(FROM_UNIXTIME(tickets.custom_data[1]), '%Y-%m-%d') AS 'Date
copy
MembantuUnhelpful
next pageFinding an Interval between Two Date/Times
previous pageRelative Dates with Placeholders

Please log in or register to submit a comment.