Modifying ac_Orders 'OrderDate'

[ReWired]

Hi there..

we are manually keying in a few entries between our data import and time to cut over and I forgot to set the new servers time back to last month so the transactions would be in the right month..

I was taking a look at ac_Orders selecting OrderDate where OrderId was > = to the order number I started entering.

So the question(s)..
1. Is it ok if I simply do an update on these OrderDate times or will it mess things up somewhere else

Select OrderId,OrderDate
FROM ac_Orders
WHERE OrderId >

2. I Noticed the time is to the either to the clock tick or 1/10000 os a sec "2010-04-08 00:05:00.320"
will it mess things up if multiple orders are the same time / value?

3. Is the same true that it's ok to Edit the ac_Payment field PaymentDate

Select OrderId,PaymentDate
FROM ac_Payments
WHERE OrderId > =

I've read that editing ac_OrderShipments field ShipDate was ok but I'm not sure about these other two dates
Thank you

Luke

[ReWired]

Ok well everything appears to be ok after update the OrderDate first the the PaymentDate then ShipDate

My update query for any one that is not up on SQL that I ran in the Microsoft SQL Server Manager query window was

UPDATE ac_Orders
SET OrderDate = '2010-03-28 10:10:21.087'
WHERE OrderId Between 3840 AND 3855

and

UPDATE ac_Payments
SET PaymentDate = '2010-03-28 11:10:21.087'
WHERE OrderId Between 3840 AND 3855

I'm a little complexed as to the time reference perhaps that's because of GMT but an entry of 22:00:00.089 seems like 2 or 4 pm while we with our server in MST

Luke