Transfering data from a table to another table!!!Help plsss..

maha

I have a pb when i transfering data from a table named INCIDENT to a table GI_INCIDENTS....

In the table INCIDENT i have startdate,enddate,starttime,endtime

And in the table GI_INCIDENTS i have startdate and enddate -->format yyyy/MM/dd hh:mm:ss.ttt..

INCIDENT is a migirated table from access...Then with a query i transfered datas to GI_INCIDENTS...

The pb is in INCIDENT Table, date of beginning incident is (2003/06/18 ) but when i excute my insert query,in the table GI_INCIDENTS, date of beginning incident is (2003/06/06)...So i have 2 days delay in the all colums...

Jeff Moden

U.S.A., United States

Joined 13 years ago

You'll find the problem in the Incident table... the migration failed to copy the correct dates somewhere. And, the difference between 2003/06/18 and 2003/06/06 is a heck of a lot more than just 2 days.

Xavier Oliquiano

, Philippines

Joined 12 years ago

Hi,

Just a suggestion, maybe its much better if you can make a little changes either in INCIDENT table or GI_INCIDENT when it comes to the datefields. I think its more ideal if the two has the same structure of fields, instead of concatenating the date and the time and put it in just one field or may be you can create a date field and a time field in GI_INCIDENT table.

“A computer is a stupid machine with the ability to do incredibly smart things, while computer programmers are smart people with the ability to do incredibly stupid things. They are, in short, a perfect match” - Bill Bryson