9

How to validate a Date in DB2

 3 years ago
source link: https://marco.dev/2016/04/20/how-to-validate-a-date-in-db2/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

This function verify if a date is valid in DB2 according to a custom date format.

-- this function return 1 if the varchar date and 0 if the date is not valid
-- the format of the date is passed in the second parameter (ex. mm/dd/yyyy)

CREATE OR REPLACE FUNCTION DB.FUNC_IS_VALID_DATE(dateToValidate VARCHAR(20), dateFormat VARCHAR(20)) RETURNS INTEGER

  BEGIN
     DECLARE functionResult INT;
     DECLARE resultingDate DATE;
     DECLARE SQLCODE INTEGER;

     DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN
         RETURN 0; -- the data is not valid
     END; -- END DECLARE

     SELECT to_date(dateToValidate, dateFormat) INTO resultingDate FROM SYSIBM.SYSDUMMY1;
     RETURN 1; -- the data is valid
  END;

Author

Marco Molteni

Marco Molteni Blog


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK