SQL Developer

• RDOT

  SSC Veteran

  Points: 204

  More actions

  November 22, 2022 at 8:38 pm

  #4116743

  ISDATE(OPS_PROJ_FMIS.STATE_OPTION_2) = True

  Trying evaluate if this OPS_PROJ_FMIS.STATE_OPTION_2 date and keep getting an error

  How Do I used IsDate Funtions in this?

   

• rjaye03

  Mr or Mrs. 500

  Points: 553

  More actions

  November 22, 2022 at 8:59 pm

  #4116744

  1=True, 0=False

  Try ... ISDATE(OPS_PROJ_FMIS.STATE_OPTION_2) = 1

• Jeff Moden

  SSC Guru

  Points: 1004617

  More actions

  November 22, 2022 at 10:16 pm

  #4116772

  Although this sounds like a strange question, why are you trying to check something to see if it's a date?  If you intend to CONVERT it without having a failure, use TRY_CONVERT() or TRY_CAST() instead.  If it's a valid DATE or DATETIME, it'll return it in the DATATYPE you specified.  If it's not valid, it'll return a null.

  Also, when you have a question on a function of this nature, it'll take you less time to look it up than to ask the question on a forum.  See the following and look for the RETURN TYPE (an INT, in this case) and a couple of the examples.

  https://learn.microsoft.com/en-us/sql/t-sql/functions/isdate-transact-sql

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)