Ir al contenido principal

How do I display dates in the US format in reports? - Base de conocimiento / Developer & Reporting / Creating Reports - Deskpro Support

How do I display dates in the US format in reports?

Lista de autores

In some geographies and organizations, date formats can appear differently to others. If you'd like to alter the format of the date in the reports you create, simply use the following clause to produce desired results:

SELECT DATE_FORMAT(tickets.date_created, '%Y-%m-%d') AS 'Date created'

For example, the following query:

SELECT DATE_FORMAT(tickets.date_created, '%Y-%m-%d') AS 'Date created', ticket_messages.date_created

Will create the following result, where the month value is displayed prior to the day value:

For more information, please refer to our guide on making reports.

Útil Poco útil

34 de 66 personas considera que esta página es útil

Nuevo comentario

Por favor, ingresa o regístrate para enviar un comentario.

¿Necesitas que te recordemos la contraseña?