Home » Interview » Technology

Write an SQL Query to check whether date passed to Query is date of given format or not.

Correct Answer: 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"; It will return 0 because passed date is not in correct format

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion