Re: [PHP-DB] Newbie: phpmyadmin and searching Unix Timestamps
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 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 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(527115)) = 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 <[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 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Newbie: phpmyadmin and searching Unix Timestamps
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 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(527115)) = 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 <[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 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
Re: [PHP-DB] Newbie: phpmyadmin and searching Unix Timestamps
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_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(527115)) = 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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Newbie: phpmyadmin and searching Unix Timestamps
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 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-DB] Newbie: phpmyadmin and searching Unix Timestamps
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