Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2011-01-30 : 03:38:42
|
| hello everybody, iam using sql server 2008 which supports TIME datatype.But when i create a column with the dataype TIME it throws error.could anyone tell me the reason. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-30 : 03:58:56
|
http://www.sqlteam.com/article/using-the-time-data-type-in-sql-server-2008what is the error?
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-01-30 : 04:20:17
|
Do you also have a default constraint on the column?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
glendcruz
Yak Posting Veteran
60 Posts |
Posted - 2011-01-30 : 18:53:41
|
quote:
Originally posted by dataguru1971
http://www.sqlteam.com/article/using-the-time-data-type-in-sql-server-2008what is the error?
Poor planning on your part does not constitute an emergency on my part.
The datatype in sql2005 and in 2008 is not Time but DateTime or smalldatetime. Is that what you want? |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2011-01-31 : 13:09:51
|
quote:
Originally posted by glendcruz
quote:
Originally posted by dataguru1971
http://www.sqlteam.com/article/using-the-time-data-type-in-sql-server-2008what is the error?
Poor planning on your part does not constitute an emergency on my part.
The datatype in sql2005 and in 2008 is not Time but DateTime or smalldatetime. Is that what you want?
You, might want to check out the new data types in SQL 2008 so you can be properly informed.Here is a link about the TIME data type:http://msdn.microsoft.com/en-us/library/bb677243.aspxHere is a link about the all data types:http://msdn.microsoft.com/en-us/library/ms187752.aspx |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-02-01 : 03:09:11
|
| See if the compatibility of database is 100MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Datatype TIME