Home » RDBMS Server » Server Administration » Date formats
Date formats [message #369190] Thu, 06 April 2000 15:05
Messages: 38
Registered: October 1999
I am getting data from a mainframe that recognizes dates as a string format. We can use the to_date string conversion to convert the string to date format within Oracle. I am wandering if there are any validation functions I can use in case the string format MM-DD-YYYY is "01002000". This would be illegal but the mainframe does not pick these entries up. Can anyone suggest anything?
Previous Topic: Rollback Segments
Next Topic: Best_design_out_of2?
Goto Forum:

Current Time: Sun Nov 27 20:39:34 CST 2022