Entering Date and Time Data

The datetime, smalldatetime, bigdatetime and bigtime datatypes consist of a date portion either followed by or preceded by a time portion (you can omit either the date or the time, or both). The date datatype has only a date and the time datatype has only the time. You must enclose values in single or double quotes.