RE: [PHP-DB] Newbie: phpmyadmin and searching Unix Timestamps
| From: | Bastien Koert | Date: | Tue, 22 Mar 2005 21:35:11 +0000 |
| Subject: | RE: [PHP-DB] Newbie: phpmyadmin and searching Unix Timestamps | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39004@lists.php.net to get a copy of this message | ||
SELECT date_format(FROM_UNIXTIME(875996580),'%Y-%m-%d'); is what I used yesterday to get around this problem
bastien
From: Graham Anderson <grahama@siren.cc> 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 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