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

Home -> Community -> Usenet -> c.d.o.misc -> to_date('01/01/97','dd/mm/yyyy')

to_date('01/01/97','dd/mm/yyyy')

From: <edwards_at_garland.dnr.state.sc.us>
Date: 1997/03/04
Message-ID: <331CACB8.2781@garland.dnr.state.sc.us>#1/1

I have written an OCI text based data entry form. The problem is that too many people like to enter two digit years instead of four. How come oracle doesn't reject two digit years when I specify 4 digit years in the date picture??

to_date('01/01/97','dd/mm/yyyy') Received on Tue Mar 04 1997 - 00:00:00 CST

Original text of this message

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