Remote server time

Hi,

I have a datetime field with the default as getdate() for every record that is added to the DB.

However my server is 12 hours back from where I am.
How can I adjust the default time so it will show my time?

Many thanks,

JackYou could use DATEADD(hour,-12,GetDate()) as the default...