Home » RDBMS Server » Server Administration » Date formats
Date formats [message #369190] Thu, 06 April 2000 15:05
Brian
Messages: 38
Registered: October 1999
Member
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?
-Brian

Report message to a moderator

Previous Topic: Rollback Segments
Next Topic: Best_design_out_of2?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 26 18:04:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.