Re: getting a date 25 years back

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Merlin wrote:
Hi there,

I am trying to create a date which is 25 years back from today. The purpose of this is to be able to query a mysql database "date" field for columns smaller than this date.

I tried this:
$years = 25;
$start_from = date("Y-m-d",strtotime("- ".$years." year"));

Somehow it always ads the years instead of subtracting.

Has anybody an idea on how to do that?

You can use mktime() and subtract 25 from the year argument.

Or just do it in your query...

SELECT * FROM yourtable WHERE your_date_column < NOW() - INTERVAL 25 YEAR;

--

---John Holmes...

Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux