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 -> Oracle Date datatype Y2K Issues

Oracle Date datatype Y2K Issues

From: Sanjay Hans <sanhans_at_mbox5.singnet.com.sg>
Date: 17 Nov 1998 14:32:00 GMT
Message-ID: <01be1237$8f47c820$40cb15a5@oempre-install>


Would appreciate your suggestions on Oracle Date datatype Y2K issue.

Is it sufficient to issue the following commands to ensure that all the date datatype fields in
the database are Y2K compliant:
alter session set nls_date_format ='DD-MON-YYYY' for each connection to Oracle session and then insert/ update the date fields in the tables. Or I should use 'DDMMRR' format to insert/update values in the date datatype fields.

Thanks in advance. Received on Tue Nov 17 1998 - 08:32:00 CST

Original text of this message

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