month-year from date, using DB2

building semantic layer
1

hi,

i want to define an object which contains month-year.
how to extract from date ?

thank u

bo_s_user (BOB member since 2004-05-19)

2

As Andreas suggested in another thread, you might want to take a look at the DB2 reference guide.

Specifically, Chapter 4 provides a list of all of the functions that you can use, including a few that may be used to extract different components from a date like month or year.

Dave Rathbun :us: (BOB member since 2002-06-06)