Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: dapperdanman1400
- Order by date
-
datetime comparison problem
No, it's still ISO, but php ISO 8601 adds a 'T' between the date and time part with no space, and MySQL has a space instead, so that was throwing it all wonky :)- dapperdanman1400
- Post #6
- Forum: MySQL
-
datetime comparison problem
OK, issue has been resolved. It was a case of the actual solution being too simple, and I was ignorant enough to think the problem was more complex than it was. I just need to format my date SPECIFICALLY to what was in the database in the column. That's what I get for being used to SQL Server...- dapperdanman1400
- Post #4
- Forum: MySQL
-
datetime comparison problem
Thanks for the tip, I've changed it now. But even after the change, it's still goofy. Both date and time are indeed there, and they are correct for the time that they were posted.- dapperdanman1400
- Post #3
- Forum: MySQL
-
datetime comparison problem
I have a query in a php page that goes something like this: SELECT * FROM posts WHERE post_time < '$php_var_date' LIMIT 0,1 I'm using this in a blog where I need the previous post's post date. php_var_date is an ISO 8601 formatted date. The post_time is of the data type datetime. While I...- dapperdanman1400
- Thread
- Replies: 6
- Forum: MySQL
