473,382 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Determining an age

Hi All,

I am wondering what the best way to determine an age of something/somone is.
For instance, let's say I have two dates:

1985-07-19
2003-11-30

Now, I want to determine the interval in years, and for each fraction of a
year, days. I won't mess with months because they can have variable length,
or if I do measure months I will simply say that a month is 30 days.

So here's my problem: normally when doing date comparison I simply convert
the dates to a UNIX timestamp. This allows me to get the number of seconds
from one date to the other. This is fine for small date ranges. For
instance, let's say I had these dates:

1985-07-19
1985-11-15

Once I get the number of seconds, I simply divide by 86400 in order to
determine the number of days.

But things get complicated once the date range gets large enough, because I
now have to worry about leap years. Every 4 years we have an extra 86400
seconds in a year. So how do I handle this case? If I want to know the
number years and days for two dates that are far apart, like the two I
listed at the beginning, what should I be doing? How do I account for leap
years, where there is an extra day?

I'm looking at PHP's builtin date and time functions, and nothing seems to
handle the case I've got in mind. Do I have to roll my own solution here
and check to see whether or not each year in my daterange is a leap year?

Thanks for any pointers!

Sincerely,
-Josh
Jul 17 '05 #1
8 1936
FUT is now set to comp.lang.php, sorry I missed that on the initial posting.

"Joshua Beall" <jb****@donotspam.remove.me.heraldic.us> wrote in message
news:pD2Wd.77751$wc.33781@trnddc07...
Hi All,

I am wondering what the best way to determine an age of something/somone
is. For instance, let's say I have two dates:

1985-07-19
2003-11-30

Now, I want to determine the interval in years, and for each fraction of a
year, days. I won't mess with months because they can have variable
length, or if I do measure months I will simply say that a month is 30
days.

So here's my problem: normally when doing date comparison I simply convert
the dates to a UNIX timestamp. This allows me to get the number of
seconds from one date to the other. This is fine for small date ranges.
For instance, let's say I had these dates:

1985-07-19
1985-11-15

Once I get the number of seconds, I simply divide by 86400 in order to
determine the number of days.

But things get complicated once the date range gets large enough, because
I now have to worry about leap years. Every 4 years we have an extra
86400 seconds in a year. So how do I handle this case? If I want to know
the number years and days for two dates that are far apart, like the two I
listed at the beginning, what should I be doing? How do I account for
leap years, where there is an extra day?

I'm looking at PHP's builtin date and time functions, and nothing seems to
handle the case I've got in mind. Do I have to roll my own solution here
and check to see whether or not each year in my daterange is a leap year?

Thanks for any pointers!

Sincerely,
-Josh

Jul 17 '05 #2

"Joshua Beall" <jb****@donotspam.remove.me.heraldic.us> wrote in message
news:pD2Wd.77751$wc.33781@trnddc07...
Hi All,

I am wondering what the best way to determine an age of something/somone is. For instance, let's say I have two dates:

1985-07-19
2003-11-30

Now, I want to determine the interval in years, and for each fraction of a
year, days. I won't mess with months because they can have variable length, or if I do measure months I will simply say that a month is 30 days.

So here's my problem: normally when doing date comparison I simply convert
the dates to a UNIX timestamp. This allows me to get the number of seconds from one date to the other. This is fine for small date ranges. For
instance, let's say I had these dates:

1985-07-19
1985-11-15

Once I get the number of seconds, I simply divide by 86400 in order to
determine the number of days.

But things get complicated once the date range gets large enough, because I now have to worry about leap years. Every 4 years we have an extra 86400
seconds in a year. So how do I handle this case? If I want to know the
number years and days for two dates that are far apart, like the two I
listed at the beginning, what should I be doing? How do I account for leap years, where there is an extra day?

I'm looking at PHP's builtin date and time functions, and nothing seems to
handle the case I've got in mind. Do I have to roll my own solution here
and check to see whether or not each year in my daterange is a leap year?

Thanks for any pointers!

Sincerely,
-Josh


Calculate the way a human would.

First, figure out when was the person's last birthday. If the person was
born in 1985-07-19, then he last celebrated his birthday on 2004-07-19.
Subtract the Unix time of that from the current time and divide by the
number of seconds in a day to get the number of days old.

Subtract the birth year from the current year to get the number of years
old. If the person hasn't celebrated his birthday yet this year, subtract
one.
Jul 17 '05 #3
.oO(Chung Leong)
Calculate the way a human would.

First, figure out when was the person's last birthday. If the person was
born in 1985-07-19, then he last celebrated his birthday on 2004-07-19.
Subtract the Unix time of that from the current time and divide by the
number of seconds in a day to get the number of days old.


What if the person was born on 1965-07-19?

I would avoid Unix timestamps because of their range restriction and use
some library for date calculations (IIRC there's something in PEAR).
Another way would be to make use of PHP's calendar functions, but these
might not be compiled in by default.

Micha
Jul 17 '05 #4
Hey,

That really sucks huh? And when 2038 (I think) rolls around, the bits will
be maxed out! Amazing how they can create such a solid OS and not even
consider these things.

Anyway, I found a solution at php.net.
Check it out at http://www.php.net/mktime in the comments, or read below!!

Thanks,
Mike

----------------------------------------------------------
If you want to calculate dates before 1970 and your OS doesn't support it
(Windows and Linux), you can easily write your own wrapper to mktime to do
the calculation. The idea is to find a date range in the 1970-2037 time
frame that is the same as your year prior to 1970 (both years start on the
same day of the week and leap years are the same), then add that number of
years to your year value before calling mktime() and then subtract the
corresponding number of seconds from the mktime() result (including the
appropriate number of leap seconds). This way old guys like me (born in
1963) can get a valid number back from mktime() and we can figure out how
old we are in seconds. :-) You can go all the way back to 1902 if you
want.

The mapping is as follows:
1902-1951 = 1986-2035
1952-1969 = 1980-1997
By matching starting day of week for the year and leap years then we should
calculate daylight time correctly (assuming that we have the right rules
set). There's a special hack in the code to turn off daylight time prior to
1942 for date().

Here's the code that we're using now:

//
// Replacement for mktime that does dates before 1970
//
function MakeTime()
{
$objArgs = func_get_args();
$nCount = count($objArgs);
if ($nCount < 7)
{
$objDate = getdate();
if ($nCount < 1)
$objArgs[] = $objDate["hours"];
if ($nCount < 2)
$objArgs[] = $objDate["minutes"];
if ($nCount < 3)
$objArgs[] = $objDate["seconds"];
if ($nCount < 4)
$objArgs[] = $objDate["mon"];
if ($nCount < 5)
$objArgs[] = $objDate["mday"];
if ($nCount < 6)
$objArgs[] = $objDate["year"];
if ($nCount < 7)
$objArgs[] = -1;
}
$nYear = $objArgs[5];
$nOffset = 0;
if ($nYear < 1970)
{
if ($nYear < 1902)
return 0;
else if ($nYear < 1952)
{
$nOffset = -2650838400;
$objArgs[5] += 84;
// Apparently dates before 1942 were never DST
if ($nYear < 1942)
$objArgs[6] = 0;
}
else
{
$nOffset = -883612800;
$objArgs[5] += 28;
}
}

return call_user_func_array("mktime", $objArgs) + $nOffset;
}

In Linux, the values returned will work just fine with date() and I believe
that strftime() should work too, but Windows doesn't like the negative
values at all. We had to write a replacement for strtotime since it appears
to call mktime() to come up with the final result.

I hope that this helps someone.

- todd

"Joshua Beall" <jb****@donotspam.remove.me.heraldic.us> wrote in message
news:pD2Wd.77751$wc.33781@trnddc07...
Hi All,

I am wondering what the best way to determine an age of something/somone
is. For instance, let's say I have two dates:

1985-07-19
2003-11-30

Now, I want to determine the interval in years, and for each fraction of a
year, days. I won't mess with months because they can have variable
length, or if I do measure months I will simply say that a month is 30
days.

So here's my problem: normally when doing date comparison I simply convert
the dates to a UNIX timestamp. This allows me to get the number of
seconds from one date to the other. This is fine for small date ranges.
For instance, let's say I had these dates:

1985-07-19
1985-11-15

Once I get the number of seconds, I simply divide by 86400 in order to
determine the number of days.

But things get complicated once the date range gets large enough, because
I now have to worry about leap years. Every 4 years we have an extra
86400 seconds in a year. So how do I handle this case? If I want to know
the number years and days for two dates that are far apart, like the two I
listed at the beginning, what should I be doing? How do I account for
leap years, where there is an extra day?

I'm looking at PHP's builtin date and time functions, and nothing seems to
handle the case I've got in mind. Do I have to roll my own solution here
and check to see whether or not each year in my daterange is a leap year?

Thanks for any pointers!

Sincerely,
-Josh

Jul 17 '05 #5
"Michael Fesser" <ne*****@gmx.net> wrote in message
news:a3********************************@4ax.com...
.oO(Chung Leong)
Calculate the way a human would.

First, figure out when was the person's last birthday. If the person was
born in 1985-07-19, then he last celebrated his birthday on 2004-07-19.
Subtract the Unix time of that from the current time and divide by the
number of seconds in a day to get the number of days old.


What if the person was born on 1965-07-19?


His birthday would still be July 19th. That doesn't change anything.
Jul 17 '05 #6
.oO(Chung Leong)
"Michael Fesser" <ne*****@gmx.net> wrote
What if the person was born on 1965-07-19?


His birthday would still be July 19th. That doesn't change anything.


The age calculation using Unix timestamps will fail.

Micha
Jul 17 '05 #7

"Michael Fesser" <ne*****@gmx.net> wrote in message
news:vh********************************@4ax.com...
.oO(Chung Leong)
"Michael Fesser" <ne*****@gmx.net> wrote
What if the person was born on 1965-07-19?


His birthday would still be July 19th. That doesn't change anything.


The age calculation using Unix timestamps will fail.


Not for another three decades. Read the original message and my response
again.
Jul 17 '05 #8
.oO(Chung Leong)
Not for another three decades. Read the original message and my response
again.


Got it. Sorry, my fault. Read too fast.

Micha
Jul 17 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: D & J Gilchrist | last post by:
Hi Is there any way of determining the width and height of a graphic in pixels (.jpg) and reporting this? Also, maybe following the above, can a picture-box position be automatically moved to...
12
by: Cliff Wells | last post by:
Hi, I'm writing an application that needs to know if an Internet connection is available. Basically, I want to have something similar to what a lot of email clients have, where the app can work...
0
by: Stephen Nesbitt | last post by:
All: Here's my implementation problem. I have a base class which has the responsibility for providing entry into the logging system. Part of the class responsibility is to ensure that lagger...
2
by: Luca | last post by:
I have the following problem: I'm developing a system where there are some processes that communicate each other via message queues; the message one process can send to another process is as...
1
by: Simon Wigzell | last post by:
I am adapting a javascript pulldown menu system to my dynamic website generator - the arrays that hold the menu items information are read from a database and will be different for different users...
2
by: Phil Galey | last post by:
In VB.NET I find the IO object very handy in replacing most of the functionality of the FileSystemObject. One exception, however, is in determining the size of a file. How can you determine the...
12
by: Raja | last post by:
How to know the buffer size and increase buffer size in c++.
4
by: - Dazed | last post by:
If a user is using a combination of Win98 & any version of MSIE, I want to display a message. The best that I can do is the following: <? if ((strstr (getenv('HTTP_USER_AGENT'), 'MSIE')) &&...
3
by: Fred Nelson | last post by:
I'm devloping a Web Application in VB.NET. In my web.config file I have specified that untrapped errors are to be sent to the page "errorpage.aspx". This is working fine - if an untrapped error...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.