Post reply

Issues with IsDate()

  • January 27, 2011 at 8:22 pm

    #388725

    Comments posted to this topic are about the item Issues with IsDate()

  • January 28, 2011 at 2:15 am

    #1279572

    Using that Stuff example, wouldn't that be the same things as:

    select isdate('1753'+ ' ')

  • January 28, 2011 at 2:57 am

    #1279589

    I'm confused as to why you would consider '1753' to be an invalid date (assuming we're using the Julian calendar).

    Datetime datatype runs from 1st January 1753, and the implicit and explicit conversions of '1753' are 1753-01-01.

    Also if it's just 1753 you have a problem with, then your method doesn't work anyway; try

    select isdate(Stuff('2011', 4, 0, ' '))

  • January 28, 2011 at 3:13 am

    #1279593

    And what happens if you actually send a real date to isdate using this so-called 'workaround'? It fails, of course, so what possible use is it? Surely you would check to see if the input to the function even resembled a date, rather than attempting to handle integers in this way. Non-problem which has produced a non-solution, sorry.

  • January 28, 2011 at 7:12 am

    #1279689

    i dont understand the usage of any such formula ?

    can anyone explain the real scenario where this is useful.

    for any input in select isdate(Stuff('input', 4, 0, ' '))

    it gives me '0' answer ,

  • May 17, 2016 at 7:04 am

    #1879523

    Interesting comments about dates.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply