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 |
|
vasu4us
Posting Yak Master
102 Posts |
 Posted - 2006-06-08 : 10:08:33
|
| HOW TO CONVERT THE VALUES IN DATETIME COLUMN FOR EX2006-03-17 03:56:00.000TO 2006-03-17 00:00:00.000I HAVE TO COMPARE ONLY DATE TO EXTRACT REPORTS.THANKS IN ADV |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-08 : 10:10:12
|
| Select DateAdd(day,DateDiff(day,0,Datecolumn),0) from yourTableMadhivananFailing to plan is Planning to fail |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-06-08 : 10:11:00
|
[code]select dateadd(day, datediff(day, 0, datecoumn), 0)[/code]
KH |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-06-08 : 10:11:51
|
Damn !  slower again
KH |
|
|
|
vasu4us
Posting Yak Master
102 Posts |
Posted - 2006-06-08 : 10:23:08
|
| HAY THANKS ALL IT WORKS, THIS HELPES ME IN COMPARING A LOT OF TABLES WITH RESPECT TO TIME DIMENSION THANKS ALOT |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
|
|
DATE FUNCTION