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 |
|
aashna_a
Starting Member
2 Posts |
 Posted - 2007-03-31 : 08:44:41
|
| Is there any datatype only for date....other than datetime.... |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-31 : 08:54:39
|
No. You have to use datetime data type
KH |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-31 : 11:18:47
|
| Katmai is another hope for date and time seperate datatypes...MohammedU |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-04-02 : 02:52:23
|
quote:
Originally posted by aashna_a
Is there any datatype only for date....other than datetime....
If you want to display data at front end, you can easily drop time part using FORMAT functionMadhivananFailing to plan is Planning to fail |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
aashna_a
Starting Member
2 Posts |
Posted - 2007-04-03 : 00:21:58
|
| Thanks guys.... |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Date Datatype.