Getdate()+ so many hours

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian - 26 Jun 2008 13:57 GMT

Hi there

Hopefully this will be an easy one for someone. I am using SQL Server 2005.
I am based in the UK and our users are in the UK. We have recently changed
hosting providers and their server is located in the USA.

Our database has a default value of getdate() when a record is added however
as the server is set to the time in the USA, which I guess is for maintenance
reasons as it is a managed server. I was thinking that I would be able to add
or subtract the time difference on to this?

Does anyone have any idea of the syntax. I know that if it was plus a day I
would do something like getdate()+1 but how do you do it for part of a day?

Any help much appreciated.
Thanks
Brian

Reply to this Message

Russell Fields - 26 Jun 2008 14:03 GMT

Brian,

DATEADD (datepart, number, date)

Also, as a FWIW you can add GETDATE() + 0.333, but that is not what you are
after this time.

RLF

> Hi there
>
[quoted text clipped - 19 lines]
> Thanks
> Brian

Reply to this Message

Brian - 26 Jun 2008 14:25 GMT

This worked perfectly. I just worked out the difference was actually + 6
hours so I changed it to GETDATE()+0.25 and it seems to work a treat.

Thanks a million!

Brian

> Brian,
>
[quoted text clipped - 28 lines]
> > Thanks
> > Brian

Reply to this Message

Russell Fields - 26 Jun 2008 15:55 GMT

Brian,

But what is the effect of Daylight Savings Time on your application? I ask
without doing all the research necessary to actually understand how US and
UK daylight savings time relate or fail to relate. 6 hours is easy, but 5
hours is not so easy by using decimals. (0.208333333333333...). So, I
actually would suggest using DATEADD for date arithmatic.

However, it may be that GETUTCDATE() would serve you better in this case.

RLF

> This worked perfectly. I just worked out the difference was actually + 6
> hours so I changed it to GETDATE()+0.25 and it seems to work a treat.
[quoted text clipped - 39 lines]
>> > Thanks
>> > Brian

Reply to this Message