Widget time format query

[QEHNick]

Can someone please correct me here. Why does this....

 DATE_FORMAT(h_fixby, '%d/%m/%Y @ %h:%m') AS "Fix Target"

Result in these incorrect times? (dates are correct).

 

Thank you and have a splendid day.

[Steve Giller]

@QEHNick%m is Month, you need %i for minutes.

[QEHNick]

Thanks @Steve Giller, that fixes the minutes, but the hour is still wrong. What's the secret there?

 

 vs. 

 

[QEHNick]

Got it! Capital H

DATE_FORMAT(h_fixby, '%d/%m/%Y @ %H:%i') AS "Fix Target"

DATE_FORMAT(h_fixby, '%d/%m/%Y @ %H:%i') AS "Fix Target"

[SamS]

@QEHNick

FWIW:

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format

https://www.w3schools.com/sql/func_mysql_date_format.asp

 

[QEHNick]

Cheers @SamS, I had a look around the net; there was so many different SQL variations, I wasn't sure where to go. So lots of trial and error involved; thanks for the resources, I'll bookmark them.

[SamS]

Hi @QEHNick,

The hint was here: https://wiki.hornbill.com/index.php?title=Hornbill_Cloud_and_Platform - under the header: Instance Storage Quota

[QEHNick]

Thanks for the info @SamS.  I've never heard of MariaDB before.

[SamS]

@QEHNickit is a clone/fork of MySQL - by the creator of MySQL after he sold MySQL to Oracle.