| Date Format [message #36111] |
Tue, 06 November 2001 06:12  |
kriser
Messages: 11
Registered: October 2001
|
Junior Member |
|
|
Does anyone know of a function or procedure in Oracle that you can pass a date from a file to check whether it is a valid date format or not? The format for the date coming in from the file may be dd-mmm-yyyy, mm/dd/yyyy, yyyy-mm-dd, etc. I want to validate the date is a format Oracle will accept before attempting to insert a row into the database. I need to skip processing the record if the date format is incorrect.
Thanks for any help anyone can provide.
KR
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
