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
g


On 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.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to