Kevin3374 Posted February 28, 2008 Share Posted February 28, 2008 I have a bunch of dates in a MySQL table that were inserted using FROM_UNIXTIME and stored in a field of type DATE. When I execute a query a SELECT query using UNIX_TIMESTAMP I get nothing. However, if I write a regular SELECT without UNIX_TIMESTAMP, I get the correct dates back, but as strings. Anyone have any ideas on why UNIX_TIMESTAMP is causing problems. Something else interesting, is when I run the query from the MySQL console itself, the query works. But when I execute the same query from within a PHP script, I get nothing. Any thoughts or tips would be greatly appreciated. Link to comment https://forums.phpfreaks.com/topic/93598-question-regarding-from_unixtime-and-unix_timestamp/ Share on other sites More sharing options...
Kevin3374 Posted February 29, 2008 Author Share Posted February 29, 2008 bump de bump you gotta bump de bump Link to comment https://forums.phpfreaks.com/topic/93598-question-regarding-from_unixtime-and-unix_timestamp/#findComment-480256 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.