> 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.com