June 23, 2009 at 12:24 pm
I have field with smalldatetime data type, when i extract data from the source to a different database, i value i get is different.
(Source)Date = 2004-01-21 00:00:00
(Dest ) Date = 2004-01-21 00:00:00.000
why do i get 3 more decimals in the destination db where both the data types are same " smalldatetime"
June 23, 2009 at 12:40 pm
What are you using to extract data and view it?
June 23, 2009 at 12:42 pm
If your destination column is smalldatetime, it shouldn't have the milliseconds added on as decimals at the end. Are you 100% it's smalldatetime and not datetime?
June 23, 2009 at 12:50 pm
yes both are smalldatetime.
when extract data using ssis pkg i am not getting the 3 additional decimals bu when do a regular insert i am getting them.
June 23, 2009 at 1:08 pm
Tara (6/23/2009)
yes both are smalldatetime.when extract data using ssis pkg i am not getting the 3 additional decimals bu when do a regular insert i am getting them.
Do the destination values ever have anything in the ms datepart other than 0?
It's not 100% clear what is happening, but I suspect that when you view the destination values, they are getting converted to regular datetime values somehow. If the answer to my question is yes, I would strongly suspect that this is the case.
June 23, 2009 at 1:18 pm
can you post create table statements
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply