Return to Snippet

Revision: 57045
at May 8, 2012 23:05 by lance


Initial Code
^(([1-9])|(0[1-9])|(1[0-2]))\/(([0-9])|([0-2][0-9])|(3[0-1]))\/(([1][9][0-9][0-9])|([2][0][0-7][0-9]))$

Initial URL


Initial Description
This only constraint here for smalldatetime is the year which allows 1900-2079. This does allow normal months and days so you could go outside the smalldatetime since that allows only 1/1/1900-6/6/2079.

Initial Title
Regular expression for smalldatetime in SQL

Initial Tags


Initial Language
Regular Expression