Revision: 57045
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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