Obtaining Age

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

Article #251

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

#251

From: Gerald Lightsey
Date: Fri, 18 Dec 1998 00:00

9 lines
631 bytes

Given a field DOB in MYTABLE containing Date of birth, what would be the 
proper local SQL syntax to obtain AGE?

What would be the syntax to obtain the first character of age (e.g. 3 for 
anyone ages 30 to 39)?

Thanks,

Gerald

Technical Details

Message-ID: <MPG.10e4a81d2baa73d39897d4@forums.borland.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,13e5acd5c576586a,start
X-Google-Attributes: gidff5a1,public
From: glightsey@cari.net (Gerald Lightsey)
Subject: Obtaining Age
Date: 1998/12/18
Message-ID: <MPG.10e4a81d2baa73d39897d4@forums.borland.com>
X-Deja-AN: 423809797
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql