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

comparing period and date

29 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.01.2005

yyy 01.02.2005

yyy 02.01.2005

yyy 01.03.2006

will the statement..

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

pls help.