Re: Newbie: phpmyadmin and searching Unix Timestamps

[Graham Anderson <grahama@xxxxxxxx>]

So how would you build the query without knowing the unix TimeStamp as 
'1111527115' is the current date ?  I am trying to build the query so 
it dynamically know what to look for

like
 SELECT * FROM SessionTable WHERE MONTH(from_unixtime(all available 
records)) = 'March';

is something like this possible ?

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.

On Mar 22, 2005, at 1:35 PM, Bastien Koert wrote:

> SELECT date_format(FROM_UNIXTIME(875996580),'%Y-%m-%d'); is what I 
> used yesterday to get around this problem
>
> bastien
>
> > From: Graham Anderson <grahama@xxxxxxxx>
> > To: php-db@xxxxxxxxxxxxx
> > Subject:  Newbie: phpmyadmin and searching Unix Timestamps
> > Date: Tue, 22 Mar 2005 12:10:15 -0800
> >
> > 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
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

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