Skip to Content (Press Enter)
2016-04-21 20-09-55
J.
 
MVP
3Views
1Comments
handling 01-01-0001 as date in oracle with Outsystems 8.0
Question
Oracle
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?


0
0
26 Aug 2013
Copy Link
2016-04-21 20-09-55
J.
 
MVP
well, actually it was pretty simple after all.

advanced queries and some checks.

0
0
27 Aug 2013
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.