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

----------------------------------------------------------------------
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:
http://www.revealnet.com/Pipelines/PLSQL/archives.htm#code15

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


Current Time: Thu Mar 28 12:06:17 CDT 2024