Passer au contenu principal

Custom date field not working with format function - Base de connaissances / Developer & Reporting / Creating Reports - Deskpro Support

Custom date field not working with format function

Liste des auteurs

Question:

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?

 

Answer:

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'

Utile Peu Utile

50 personnes sur 93 ont trouvé cette page utile

Ajouter un commentaire

Veuillez vous connecter ou vous enregistrer pour soumettre un commentaire.

Besoin d'un rappel de mot de passe?