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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.