Date validation oops!

[saustin]

Have a user who entered '8/1007' into a text field that when converted to a date resulted in the year 2007. Not good ! Any other date validation tricks out there that might be preferable ?

Thanks.

SQL> select TO_CHAR(TO_DATE('8/1007', 'MM-DD-RRRR') ,'YYYY') from dual;

TO_C
----
2007

SQL>

 

[SantaMufasa]

Any other date validation tricks out there that might be preferable ?

Steve, what are you asking for us to suggest here?...Preferable to what? The very first "trick" that I would ALWAYS recommend in the Oracle World is: Never use/allow anything but a DATE column type to store DATE data.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.