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:
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
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
wrote:
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
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 Mar 2005 15:06:35 -0800
So how