Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2015
    Posts
    2

    Post Unanswered: How to check the date format is correct or not in DB2

    Hi Folks,

    I am new to DB2, help me learn DB2, I have few date columns in tables for which I want to check if that column is in correct DATE format or not ?? what would be the query to check the date format. I know there is ISDATE function in sql and I am not sure what is the equivalent in DB2 ??

    Thanks in advance for your help.

    Regards,
    R

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    If your column is set as DATE, then all the values in that column are correct - DB2 checks that at insert/update time.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •