MSSQL – Valid Date

Posted on By David Kittell

Validate a non-DateTime data type field is a really a date.

SET LANGUAGE English; -- Not necessary but can be helpful
SELECT ISDATE('15/04/2008'); --Returns 0.
SELECT ISDATE('04/15/2008'); --Returns 1.
Originally Posted on March 14, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL SQL

Related Posts

List All Files In Folder

Posted on

<?PHP function getDirectory( $path = ‘.’, $level = 0 ){ $ignore = array( ‘cgi-bin’, ‘.’, ‘..’ ); // Directories to ignore when listing output. Many hosts // will deny PHP access to the cgi-bin. $dh = @opendir( $path ); // Open the directory to the handle $dh while( false !==…

Read More

UNIX Terminal – Grep Directory Recursively

Posted on

Sometimes you really need to find a file that has certain text in it, these commands will help provided you have an idea of the directory or the string grep -R ‘final exam’ ~/Documents # OR find ~/Documents -type f -exec grep -H ‘final exam’ {} + All information on…

Read More