Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is using a high date 12/31/999 a problem, since oracle only goes to 4712 A.D.
we are using a high date of 12/31/9999 as a default date. We compare it against other dates and update fields that have that date like the following
update ti_cims_billing_snapshot
set bill_issue_dt = to_date('31-dec-9999')
where bill_issue_dt = to_date('01-jan-0001')
and acct_typ = '51'
is there any problem? Received on Thu Nov 18 1999 - 16:58:24 CST