Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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.

Is using a high date 12/31/999 a problem, since oracle only goes to 4712 A.D.

From: mosene <nousene_at_mailer.com>
Date: 18 Nov 1999 16:58:24 -0600
Message-ID: <Lv%Y3.8079$xy4.11529@sol.newscene.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US