Skip to Content
avatar image
Former Member

Month to date, year to date objects

Can any body tell me, how to create "Month to date" and "Year to date" objects in the business layer from a date field. My backend source is Oracle 11g and date format is ddMMMyyyy.


Thanks for any help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 03, 2013 at 06:06 AM

    You can use TO_CHAR(<date field>, MON) to get Month and TO_CHAR(<date field> , YYYY) to get year.

    Thanks

    -Nanda

    Add comment
    10|10000 characters needed characters exceeded