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 |
|
ZMike
Posting Yak Master
110 Posts |
 Posted - 2010-05-11 : 10:41:26
|
| I have a time issue in a couple of our tables that we're looking to replicate On the original Source it's labled as a Decimal 4,0 field but it somehow put's the colon " : " into the queryWhen I pull it into a replicated table it comes across as a 4 decimal field starting with 0 and stopping at 2359 (Military time is fine) However because there is no : in the mix if I try and do a datediff with hours it subtracts by 100 instead of the minutes. Some of these are very large tables so I figured I'd see what the best suggestions were. |
|
|
ZMike
Posting Yak Master
110 Posts |
Posted - 2010-05-11 : 10:48:17
|
| Which brings me to another issue.We have another field or two that it tries to put in a date time when it's really just a date field so it throws 0:00:00 on to everything which doenst bother me but tends make the date to appear "0" when I export something to excel. On a table with a million plus rows what would be the best way to take it out with the least over head on a server and just leave a date ? |
 |
|
|
ZMike
Posting Yak Master
110 Posts |
Posted - 2010-05-20 : 16:25:55
|
| Just bringing back to the front. I havent gotten back to this issue to mess with it more yet but figured maybe someone new may see it. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-05-21 : 04:22:34
|
| Can you post table DDL and sample input data?Some of us may be having difficulty understanding what your problem is, thus the lack of interest to date. |
|
|
|
|
|
|
Time Issue