Dot Net
Thursday, 23 May 2013
Write an SQL Query to check whether date passed to Query is date of given format or not?
SQL has IsDate() function which is used to check passed value is date or not of specified format ,it returns 1(true) or 0(false) accordingly.
SELECT
ISDATE
(
'1/08/13'
)
AS
"MM/DD/YY"
;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment