Subject | how to get a monthly report? ref/eDN6082872122 |
---|---|
Author | dennis |
Post date | 2007-07-19T05:18:40Z |
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?
Regards
Dennis
[Non-text portions of this message have been removed]
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?
Regards
Dennis
[Non-text portions of this message have been removed]