Select Specific Month

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Henry Olive Fri, 13 Dec 2002 21:19

#11125

Author: 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.

Re: Select Specific Month

#11126

Author: 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)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads