SELECT * FROM SessionTable WHERE date_format((from_unixtime(fieldname),'%M')
= 'March';
should do the trick
bastien
From: Graham Anderson <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Newbie: phpmyadmin and searching Unix Timestamps
Date: Tue, 22
So how would you build the query without knowing the unix TimeStamp as
'527115' 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
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_UNIXTI
SELECT date_format(FROM_UNIXTIME(875996580),'%Y-%m-%d'); is what I used
yesterday to get around this problem
bastien
From: Graham Anderson <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] Newbie: phpmyadmin and searching Unix Timestamps
Date: Tue, 22 Mar 2005 12:10:15 -0800
is there