situation:
$date1 = date("Y-m-d");
$date2 = "2007-01-12";
problem:
how to find the no of days between $date1 and $date2 ?
Any help is appreciated...
Thank you
find the no of days?
Moderator: General Moderators
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
-
impulse()
- Forum Regular
- Posts: 748
- Joined: Wed Aug 09, 2006 8:36 am
- Location: Staffordshire, UK
- Contact:
This may work:
Code: Select all
$date1A = strtotime($date1);
$date2A = strtotime($date2);
$total = $date2A - $date1A;
$AOD = $total / 86400;
echo "Amount of days is {$total}";Hey i got the solutions
solution 1: using php
solution 2: using mysql
solution 1: using php
Code: Select all
echo (strtotime($date1) - strtotime($date2)) / 86400;Code: Select all
select datediff(now(), '2007-01-12') as days
Last edited by PHPycho on Sat Feb 10, 2007 9:51 am, edited 1 time in total.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA