|
Sahithikalluri
Starting Member
India
1 Posts |
 Posted - 11/17/2012 : 00:42:31
|
DECLARE @datetimeoffset datetimeoffset(3)
DECLARE @datetime datetime
SELECT @datetimeoffset = '2012-11-08T17:22:13.575+00:00'
SELECT @datetime = @datetimeoffset
SELECT @datetimeoffset AS '@datetimeoffset ', @datetime AS 'datetime'
_____________________________________________________________
Result of above SQL is
@datetimeoffset datetime
2012-11-08 17:22:13.575 +00:00 2012-11-08 17:22:13.577
______________________________________________________________
The result should be '2012-11-08 17:22:13.575', can anyone please let me know why the milliseconds value is incorrect
K Sahithi |
|
Issue while converting datetimeoffset to datetime
