メインコンテンツへスキップ

How do I display dates in the US format in reports? - ナレッジベース / Using Deskpro / Reports - Deskpro Support

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

作成者一覧

In some geographies and organizations, date formats can appear differently from others. If you'd like to alter the format of the date in the reports you create, simply use the following clause to produce the 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

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

参考になった 役に立たない

66 人中 34 人がこのページは参考になったと答えました