Skip to Content
3
Former Member
Jul 26, 2007 at 12:37 PM

How to convert Year from 4 digit to 8 digit in the where condition

47 Views

Hello every one.

Can any body help me in solving this please:

The year must be entered in 4 digit format for EX...2005 but the dbtab-year is in 8digit format(20050923).

parameters: p_year type dbtab-year

select *  from dbtab
 into corresponding fields of table it_tab  where year = p_year

How could I limit the year in the entry screen to 4 digits but it could still be used in the where condition referring to dbtab-year(dbtab-year is in 8digits).

I would really much appreciate and help. Thank you all in advance.

Nina.