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