Thank you Thomas for your fast reply!



Dennis



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: Thursday, July 19, 2007 8:43 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] how to get a monthly report?
ref/eDN6082872122

> Hello to all
>
>
>
> I have a field timestamp and I want to get a monthly report according this
> field.
>
> If order to get a daily report I used the cast like this
>
> cast (ISSUE_DATE as DATE)) date_
>
> and I group the query with this field.
>
>
>
> How may I get the number of the month of a timestamp field?

EXTRACT(MONTH FROM MYTIMESTAMP)

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene <http://www.upscene.com> com





[Non-text portions of this message have been removed]