DATE_FORMAT SQL Issue

user03116 · October 2019

Hi There,

I'm tyring to convert my date field from a 12 hour time stamp, to a 24 hour timestamp. I tried using DATE_FORMAT(`Date Field`, '%Y-%m-%d %H:%m:%s') but it gives me a completely different date AND time than what the actual value is.

Has anyone ever encountred a similar issue and have any advice. Thanks!

Cartergan · October 2019

The documentation found in the Knowledge Base has always helped me when it comes to formating my dates/times: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/03Date_Format_Specifier_Characters_in_Beast_Mode

To convert to 24 hour try:

DATE_FORMAT('Date Field', '%T')

Let me know if this helps!

user03116 · October 2019

Thanks for your response! My issue is that when I use any of those functions, it completely changes the date. For example, the date 10/2/2019 8:14 PM becomes 2019-10-03 01:07:30 when using the funciton DATE_FORMAT(`Date Field`, '%Y-%m-%d %T'). Is there some sort of additional calculation I should be doing?

Cartergan · October 2019

It must be something with the data type of the date. What data type does it say it is?

Magic ETL

Magic ETL

DATE_FORMAT SQL Issue

Welcome!

Comments

Welcome!

Welcome!

Quick Links

Categories