|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
September 16th, 2004, 10:46 AM
|
|||
|
|||
|
can't get a date... to import
I am new to this forum, but it looks like you all know your stuff.
We have an Access database that we have attempted to import into SQL server. Everything comes on over fine except for the date fields--we set them to long and all of that--but they all show up offset by two days (+2 from actual or previous unimported value). Any suggestions? I have posted to several forums but nobody has had any comments. Please help. --the Desperate Fat Kid
|
|
#2
September 16th, 2004, 11:03 AM
|
||||
|
||||
|
Quote:
what do you mean? Did you try the upsizing tool?
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
September 16th, 2004, 11:09 AM
|
|||
|
|||
|
Well, I htought it was the upsize tool. We attempted to change the date field to a larger size, accounting for the 4 byte size in Access.
It has been weird. The timestamp seems to work fine when the data is input, but it then is reflected incorrectly when ever we view the data later. I wish I knew how to better explain it. Hope this helps you help me lol.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > can't get a date... to import |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
