Home » SQL & PL/SQL » SQL & PL/SQL » Date Format
Date Format [message #36111] Tue, 06 November 2001 06:12 Go to next message
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.


Re: Date Format [message #36117 is a reply to message #36111] Tue, 06 November 2001 09:43 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
check the zip file at this link:

Previous Topic: Define or Accept Not resolved
Next Topic: Text File
Goto Forum:

Current Time: Fri May 24 12:32:03 CDT 2024