Oct 5, 2010 #1 primagic IS-IT--Management Joined Jul 24, 2008 Messages 476 Location GB My server is hosted in Europe and all the getdate() functions pull through the server time which is 1hour ahead of GMT. How can I set a field with a default value of getdate() to getdate() - 1 hour.
My server is hosted in Europe and all the getdate() functions pull through the server time which is 1hour ahead of GMT. How can I set a field with a default value of getdate() to getdate() - 1 hour.
Oct 5, 2010 #2 markros Programmer Joined May 21, 2007 Messages 3,150 Location US Use dateadd(hour,-1,getdate()) as a default PluralSight Learning Library Upvote 0 Downvote