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
