Should be is using a high date 12/31/9999 a problem, since oracle only goes to 4712 A.D.

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.

From: fdsfsd <dfdsfdsf_at_dsfwef.com>
Date: Fri, 19 Nov 1999 01:32:13 GMT
Message-ID: <3834a8bb_7@galaxy.uncensored-news.com>

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?

Posted via Uncensored-News.Com, http://www.uncensored-news.com

Only $8.95 A Month, - The Worlds Uncensored News Source Received on Thu Nov 18 1999 - 19:32:13 CST