i want to select from Table but021_fs (the business partner adress usage). I want to filter for the field "valid_to" which is DEC15.
I always get error messages.
If i use
where but021_fs.valid_to = '99991231235959' I get an data type conflict error
where but021_fs.valid_to = 99991231235959 I get an error with 4-Byte-Integer error
where but021_fs.valid_to = '99.918.104.22.1689' I get an data type conflict error
and but021_fs.valid_to = 99991231235959.0 I get an error that the value is too big.
So, how to correctly make this statement?
Thanks for your help