handling 01-01-0001 as date in oracle with Outsystems 8.0

handling 01-01-0001 as date in oracle with Outsystems 8.0

  
Hi,

We use an external oracle database. It's not used exclusively and for other applications/stored procedures
we need dates be 01-01-0001 as our null date. so 01-01-1900 is not an option, because then those other parties will not work again.

in the future we might want to search on that specific 01-01-0001 as well, so also the select needs to handle that...
 
How can we achieve this?


well, actually it was pretty simple after all.

advanced queries and some checks.