How do I check if a day is actually valid in SQL?

Category: Windows Server

In SQL Server, you can make use of the ISDATE() function to check if a worth is actually a valid date. To be actually even more details, this functionality just inspections whether the value is actually a valid time, opportunity, or even datetime worth, yet not a datetime2 value. If you supply a datetime2 worth, ISDATE() will inform you it’s certainly not a day (it will come back 0 ).

Like this post? Please share to your friends:
Leave a Reply

;-) :| :x :twisted: :smile: :shock: :sad: :roll: :razz: :oops: :o :mrgreen: :lol: :idea: :grin: :evil: :cry: :cool: :arrow: :???: :?: :!: