Re: Select Specific Month

Article View: borland.public.interbase.sql

Article #11126

Back to borland.public.interbase.sql Previous Next

#11126

From: Bill Todd
Date: Sat, 14 Dec 2002 01:47

30 lines
1558 bytes

WHERE EXTRACT(MONTH FROM SOMEFIELD) = 2

On Fri, 13 Dec 2002 23:19:40 +0200, "Henry Olive" <zed@zedltd.com>
wrote:

>D6, IB6
>
>How can i select specific month from a TimeStamp field  ?
>Field = MDATE ( TimeStamp and format=dd.mm.yyy )
>
>MDate              Total
>------------     --------
>01.01.2002        100.00
>10.01.2002        200.00
>15.02.2002        300.00
>.....
>
>i want to select only Month 02  like below.
>
>MDate            Total
>------------     -------
>15.02.2002     300.00
>
>Thank you.
>


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Technical Details

Message-ID: <3d3lvucr1kkb31msblqjp3qhhba3n7c7c3@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3dfa4ec5@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,4ce8a18dc325db01
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-13 18:07:21 PST
From: Bill Todd <bill@notthis.dbginc.com>
Newsgroups: borland.public.interbase.sql
Subject: Re: Select Specific Month
Date: Fri, 13 Dec 2002 18:47:40 -0700
Message-ID: <3d3lvucr1kkb31msblqjp3qhhba3n7c7c3@4ax.com>
References: <3dfa4ec5@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.207.212.41
X-Trace: newsgroups.borland.com 1039830461 216.207.212.41 (13 Dec 2002 17:47:41 -0800)
Lines: 30
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message