Examples for validating dates in pl sql
Examples for validating dates in pl sql - british lad dating
Along with 14 years of hands on experience he holds a Masters of Science degree and a number of database certifications. For any SQL Server Performance Tuning Issue send email at [email protected] say i have some date parameter for a procedure, i want to ensure date value passed is of format 'YYYY-MM-DD'.
He works with the system, where we import CSV file in our database.the format only comes into picture when the parameter assigned to a date variable is of varchar2 type.other instances are where you need to print the date in a specific function in which you would first convert it into a varchar2 and then print it.SQLBy the time your procedure receives the DATE parameter, the calling program has already done any necessary conversion from formatted text to DATE, and the DATE is sure to be valid. The first uses the "default" format mask, the second specifies a different one.I have seen this misconception over and over during the years.if not in the above format i have to return message date of improper format from my procedure. Thanks & Regards in Advance Well, if the parameter passed is of type DATE (which seems appropriate), there is no format to check.to_char(p_date,'DD-MON-YYYY')); 4 dbms_output.put_line('Date is also... '