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 |
|
hornet
Yak Posting Veteran
96 Posts |
 Posted - 2006-08-14 : 09:38:17
|
| Hi all! I need to get SMALLDATETIME with hours, seconds and minutes.I use select CONVERT(SMALLDATETIME, (DATEDIFF(day, 2, TimerDate))) from orTimerDate- SMALLDATETIMEbut I'm getting truncatted TimerDate with 0 hours, minutes and seconds. Also i've used CONVERT(SMALLDATETIME, (DATEDIFF(day, 2, TimerDate)), 20) but without a resultWhy? |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
Don't truncate SmallDATETIME