Issues with IsDate()

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Kameswari Aravindh » Issues with IsDate()

Issues with IsDate()

Rate Topic

Display Mode

Topic Options

Author

Message

Kameswari Aravindh

Posted Thursday, January 27, 2011 8:22 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 3:46 AM
Points: 2,223, Visits: 177

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

Post #1055059

cengland0

Posted Friday, January 28, 2011 2:15 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299

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

select isdate('1753'+ ' ')

Post #1055160

Andrew Watson-478275

Posted Friday, January 28, 2011 2:57 AM

SSC Eights!

Group: General Forum Members
Last Login: Saturday, May 18, 2013 1:44 AM
Points: 953, Visits: 1,875

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, ' '))

Post #1055179

Sam Evans-378841

Posted Friday, January 28, 2011 3:13 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 22, 2013 4:56 AM
Points: 13, Visits: 94

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.

Post #1055184

me.makwana

Posted Friday, January 28, 2011 7:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 29, 2012 8:03 AM
Points: 1, Visits: 11

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 ,

Post #1055306

« Prev Topic | Next Topic »

Permissions