DATE_FORMAT SQL Issue

user03116

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

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

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

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