Select Specific Month

Article View: borland.public.interbase.sql

Article #11125

Back to borland.public.interbase.sql Previous Next

#11125

From: Henry Olive
Date: Fri, 13 Dec 2002 21:19

19 lines
1297 bytes

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.

Technical Details

Message-ID: <3dfa4ec5@newsgroups.borland.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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,4ce8a18dc325db01,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-13 13:21:29 PST
From: "Henry Olive" <zed@zedltd.com>
Newsgroups: borland.public.interbase.sql
Subject: Select Specific Month
Date: Fri, 13 Dec 2002 23:19:40 +0200
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 195.175.163.38
Message-ID: <3dfa4ec5@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039814341 195.175.163.38 (13 Dec 2002 13:19:01 -0800)
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