Re: Obtaining Age

Article View: borland.public.vdbase.data.sql

Article #279

Back to borland.public.vdbase.data.sql Previous Next

#279

From: Ken Chan
Date: Mon, 21 Dec 1998 00:00

11 lines
888 bytes

Steve Koterski wrote:
> You could then use numeric
> arithmetic available in SQL to translate from number of days to number of
> years. One simplistic way would be to divide the number of days by 365.25.

You realize that will occasionally give you the wrong answer. It is 
impossible to accurately determine age in years given the age in days.

-- 
//Ken@Inprise
<Please follow-up to newsgroup; do not reply to email>

Technical Details

Message-ID: <MPG.10e89aa7a0829577989b73@forums>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <MPG.10e4a81d2baa73d39897d4@forums.borland.com> <368292e6.6580270@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,13e5acd5c576586a
X-Google-Attributes: gidff5a1,public
From: supportinfo@inprise.com (Ken Chan)
Subject: Re: Obtaining Age
Date: 1998/12/21
Message-ID: <MPG.10e89aa7a0829577989b73@forums>
X-Deja-AN: 424713200
References: <MPG.10e4a81d2baa73d39897d4@forums.borland.com> <368292e6.6580270@forums.inprise.com>
Organization: Inprise Corporation
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message