Re: Obtaining Age

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

Article #263

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

#263

From: Greg Hill
Date: Sun, 20 Dec 1998 00:00

10 lines
870 bytes

It might the hard way but you should be able to start with the following:

Select EXTRACT(YEAR FROM DOB) FROM MYTABLE ALIAS CYEAR
Select EXTRACT(DAY FROM DOB) FROM MYTABLE ALIAS CDAY
Select EXTRACT(MONTH FROM DOB) FROM MYTABLE ALIAS CMONTH

Of course you could store the above information to Vars and then do some
math on the Vars with what ever language you choose.

Greg Hill

Technical Details

Message-ID: <75ia5q$5ge2@forums.borland.com>

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

References: <MPG.10e4a81d2baa73d39897d4@forums.borland.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: "Greg Hill" <ghill@n2.net>
Subject: Re: Obtaining Age
Date: 1998/12/20
Message-ID: <75ia5q$5ge2@forums.borland.com>
X-Deja-AN: 424149534
References: <MPG.10e4a81d2baa73d39897d4@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message