ProgrammingThis forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
If you are using mysqli, then the mysqli_warning_count() function will tell you how many warning you have. You can then retrieve them using the SQL call SHOW WARNINGS. Check out the PHP manual for more details.
Distribution: Debian /Jessie/Stretch/Sid, Linux Mint DE
Posts: 5,195
Rep:
Not about the error message but about the error itself: 24:00 is not a valid time in MySQL. Although it should be, because it 2008-04-15 24:00 is the second after 2008-04-15 23:59.
After one full year developing a project which does a lot of date/time handling I found that it is generally better to do everything in Unix timestamps. That saves a lot of juggling between time/date and timestamps in PHP as well. Only for presentation one should use time/date, which is easy in PHP (gmtime and friends) and in MySQL any timestamp can be shown human readable as FROM_UNIXTIME(ts).
But that doesn't answer your original question, does it?
@jlinkels:
I expected the 24 to be the problem and running part of the query in the mysql client confirmed that. But it took me a while.
As I'm doing an update on an existing LAMP solution (that I wrote about 1.5 year ago) so it's a bit late to change the full design of my LAMP solution over to unix_timestamps. But I will definitely keep it in mind for the next application that I need to write.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.