MQSeries.net :: View topic

EnOne · Posted: Wed Apr 14, 2004 7:48 am Post subject:

I am using WebSphere MQ Integrator V2.1 . I thought I could calculate age by subtracting birthdate from current date.

DECLARE Birth DATE;
DECLARE Age INTEGER;

SET Birth = 1923-08-25;
SET Age = CAST((CURRENT_DATE - Birth) YEAR AS INTEGER)

-----RESULT
<Birth>1923-08-25</Birth>
<CURRENT_DATE>2004-04-13</CURRENT_DATE>
<Age>81</Age>

By my calculations, this person would not be 81 until 2004-08-25. Is there a way to calculate age without having MQ round up? I realize I could just calculate the number of days then divide by 365.25 and truncate but this feels like a bad workaround. How do other people calculate age?