Re: Newbie: phpmyadmin and searching Unix Timestamps
| From: | Aman Patel | Date: | Tue, 22 Mar 2005 21:36:49 +0000 |
| Subject: | Re: Newbie: phpmyadmin and searching Unix Timestamps | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39005@lists.php.net to get a copy of this message | ||
Graham Anderson wrote:
is there an easy way to search through unixtimestamps ? like Select * from SessionTable Where ConvertToMonthFunction(unixTimeStamp) = 'March' ? be great to use the Variable function within phpmyAdmin many thanks gOn Mysql (works on 4.0 atleast), you can use the FROM_UNIXTIME() function to convert a unix timestamp back to universal date/time format. From then on you can use any standard mysql date/time functions to compare the month. So your query becomes something like: SELECT * FROM SessionTable WHERE MONTH(from_unixtime(1111527115)) = 3; MONTH() returns a numeric month number from 1-12. See the mysql documentation on date and time functions here: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html Hope this helps.