| date field - need to group by month [message #77665] |
Thu, 01 November 2001 05:19  |
Deb
Messages: 17
Registered: November 2001
|
Junior Member |
|
|
How do I get the date field (type date) to group by month for my year-end ledger balance? The ledger entries are recorded by day, month, and year. I am using Oracle Developer/Report.
Thank you for any help on this.
Deb
----------------------------------------------------------------------
|
|
|
|
| Re: date field - need to group by month [message #77667 is a reply to message #77665] |
Thu, 01 November 2001 08:46  |
Robin
Messages: 73
Registered: October 2001
|
Member |
|
|
Dear Dov,
U can use simple substr function to cut month from date field. Like
select .... from... where...group by substr(datefield,4,7)
If can/ cannot solve ur problem in this way let me know.
Thanks
Robin
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
