Jelena
Old Hand
Points: 332
More actions
November 7, 2003 at 3:22 am
#83406
Hi,
how can i change datetime resolution?
Thanks a lot,
Wesley Brown
SSChampion
Points: 12045
November 7, 2003 at 3:47 am
#481195
datetime and smalldatetime time both have month day year hour minute second in them smalldatetime rounds to the nearest second. you have to parse the datetime ether using datepart() or like a string using substring()
Wes
Antares686
SSC Guru
Points: 125444
November 7, 2003 at 5:06 am
#481206
quote:Hi, how can i change datetime resolution?Thanks a lot,Jelena
quote:
Can you give me an example of what you mean, or what you are trying to do?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply