Skip to Content
0
Former Member
Feb 13, 2007 at 04:26 PM

comparing period and date

55 Views

hi,

Are period and date , directly comparable.

that is...i have

seloption:SO_PERIOD: 02.2005 to 03.2006

and Ztable like this...

col1 col2

xxx 01.2005

yyy 02.2005

yyy 03.2005

yyy 01.2006

yyy 04.2006

will the statement..

select col1 from ztable where col2 in so_period.....return all values

pls help.