SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Using the TIME data type in SQL Server 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 03/06/2008 :  09:08:46  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote

SQL Server 2008 introduces a TIME data type which allows us to store the time without the date.



Read Using the TIME data type in SQL Server 2008

surfandswim
Starting Member

USA
4 Posts

Posted - 04/10/2008 :  16:54:42  Show Profile  Reply with Quote
I think that this field is useful, but why not add a "Date" type without the time as well? Or do they have such a thing?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30277 Posts

Posted - 04/10/2008 :  16:55:36  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Yes they have. And six more types of date datatypes.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

sql777
Constraint Violating Yak Guru

314 Posts

Posted - 08/06/2008 :  06:38:49  Show Profile  Reply with Quote
what kind of benefits is there to using this date type over the other one?

You said index seek, what does a regular datetime column do when indexed and used in a where clause?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000