Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Should be is using a high date 12/31/9999 a problem, since oracle only goes to 4712 A.D.
In article <Lv%Y3.8079$xy4.11529_at_sol.newscene.com>, nousene_at_mailer.com (mosene) wrote:
>
>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?
Only $8.95 A Month, - The Worlds Uncensored News Source Received on Thu Nov 18 1999 - 19:32:13 CST