QEHNick Posted July 27, 2022 Share Posted July 27, 2022 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. Link to comment Share on other sites More sharing options...
Steve Giller Posted July 27, 2022 Share Posted July 27, 2022 @QEHNick%m is Month, you need %i for minutes. Link to comment Share on other sites More sharing options...
QEHNick Posted July 27, 2022 Author Share Posted July 27, 2022 Thanks @Steve Giller, that fixes the minutes, but the hour is still wrong. What's the secret there? vs. Link to comment Share on other sites More sharing options...
QEHNick Posted July 27, 2022 Author Share Posted July 27, 2022 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" Link to comment Share on other sites More sharing options...
SamS Posted July 27, 2022 Share Posted July 27, 2022 @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 Link to comment Share on other sites More sharing options...
QEHNick Posted July 27, 2022 Author Share Posted July 27, 2022 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. Link to comment Share on other sites More sharing options...
SamS Posted July 28, 2022 Share Posted July 28, 2022 Hi @QEHNick, The hint was here: https://wiki.hornbill.com/index.php?title=Hornbill_Cloud_and_Platform - under the header: Instance Storage Quota Link to comment Share on other sites More sharing options...
QEHNick Posted July 28, 2022 Author Share Posted July 28, 2022 Thanks for the info @SamS. I've never heard of MariaDB before. Link to comment Share on other sites More sharing options...
SamS Posted July 28, 2022 Share Posted July 28, 2022 @QEHNickit is a clone/fork of MySQL - by the creator of MySQL after he sold MySQL to Oracle. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now