Extract year from date

Article View: borland.public.jbuilder.linux

Article #4912

Back to borland.public.jbuilder.linux Previous Next

#4912

From: Mourad Ykhlef
Date: Mon, 22 Nov 1999 00:00

9 lines
636 bytes

hello

in SQL92 one van write

select MONTH(dateOfStatus)
from JobApplication

how can i do the equivalent query
in ISQL

Technical Details

Message-ID: <38390627.402E4E57@insyscom.fr>

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: 107590,c1102655550b077f,start
X-Google-Attributes: gid107590,public
From: Mourad Ykhlef <m.ykhlef@insyscom.fr>
Subject: Extract year from date
Date: 1999/11/22
Message-ID: <38390627.402E4E57@insyscom.fr>
X-Deja-AN: 551554533
Content-Transfer-Encoding: 7bit
Organization: Another Netscape Collabra Server User
X-Accept-Language: fr
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.jbuilder.linux