Comments
Sort by recent activity
I'll try this on the server in the US:
DateTimeStamp >= CONVERT(DATETIME, DATEADD(hour, - 63, GETDATE()), 102)
and this on the local server:
DateTimeStamp >= CONVERT(DATETIME, DATEADD(day, - 2, GETDATE()), 102)
and see how I go [image] / comments
I'll try this on the server in the US:
DateTimeStamp >= CONVERT(DATETIME, DATEADD(hour, - 63, GETDATE()), 102)
and this on the local server:
DateTimeStamp >= CONVERT(DATETIME, DATEADD(day, - 2, GET...
Hey Richard, your suggestion has prompted me to think about the time zones.
My local server is in US date format, but I am in Australia - the server I am trying to synchronize to is also in US date format, but physically situated in the US. So the getdate() function will give different results!
Hmmm, not sure how to get around this one. :? / comments
Hey Richard, your suggestion has prompted me to think about the time zones.
My local server is in US date format, but I am in Australia - the server I am trying to synchronize to is also in US date...
Hi James - the screens I am using are the ones on the red-gate web site just so people know what part of the process I am talking about. My screens look just fine and all the functionality works as it should. However I just cannot scroll horizontally to see all of the columns! / comments
Hi James - the screens I am using are the ones on the red-gate web site just so people know what part of the process I am talking about. My screens look just fine and all the functionality works as...