dateTime / smallDateTime 1

[CatPlus]

Hello all:

Please help me understand the following:

[1] Although BOL references 4/18/2003 11:17:42.1234 AM as a valid date, a dateTime column will only accept HH:MM:SS. Why then is a reference of milliseconds, or is it inserted when SQL updates these values via a stored procedure

[2] How can January through September be represented as 04/18/2003 instead of 4/18/2003? This is cosmetically desired when column displays single and double digit months

[3] What is the syntax to derive a column formula to default to current date and will it return 4/19/2003 or 4/19/2003 11:17:42.1234?

[4] Is there a way to define a data-type which will only record the date and not the time.... and still be useable in defining variables in stored procedures?

Thanks indeed
Mickey

 

[tlbroadbent]

See the following. Most of your questions will be answered.

Handling dates in SQL Server

http://tlbroadbent.home.attbi.com/sql/ss_datetime.htm

faq183-3007 - Why Does SQL Server Display My Data Like That?


If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm