[thelist] PHP Unix Timestamp

[CDitty]

Got it.  Thanks all

Chris

At 02:21 PM 3/29/01 -0800, you wrote:
>At 01:57 PM 3/29/2001, you wrote:
>>I'm playing ignorant this afternoon and am having too many brain 
>>farts.  Can you give an example?
>
>Sure!
>
>## Find All insert dates with in the last month
>
>SELECT * FROM db_table_name WHERE
>insert_date between NOW() AND DATE_SUB(NOW(),INTERVAL 1 MONTH)
>
>## Find All expire dates with in the next month
>
>SELECT * FROM db_table_name WHERE
>expire_date between NOW() AND DATE_ADD(NOW(),INTERVAL 1 MONTH)
>
>More here:
>
>http://www.mysql.com/doc/D/a/Date_and_time_functions.html
>
>
>----
>Anthony Baratta
>President
>Keyboard Jockeys
>
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !