Skip to main content

Custom date field not working with format function - Tudásbázis / Developer & Reporting / Creating Reports - Deskpro Support

Custom date field not working with format function

Authors list


I'm trying to create a report that includes information from a custom date field:


SELECT DATE_FORMAT(tickets.custom_data[1]), '%Y-%m-%d') AS 'Date'


However, the result table only displays None for that column. How can I fix this?



Custom date fields contain integer timestamp values, so before you use the DATE_FORMAT function, you first have to convert to real dates using FROM_UNIXTIME:


DATE_FORMAT(FROM_UNIXTIME(tickets.custom_data[1]), '%Y-%m-%d') AS 'Date'

Hasznos Nem hasznos

88 felhasználóból 48 hasznosnak találta ezt a cikket.

Kérjük ebbe a mezőbe írja hozzászólását, majd kattintson a 'Hozzászólás beküldése' gombra...

Please log in or register to submit a comment.

Need a password reminder?