SQL 2005 - Current time to GMT

If your question is just 'how can I add four hours', then use DATEADD()

SELECT DATEADD(hour, 4, GETDATE())

Select allOpen in new window

If your question is 'How can I convert any given GETDATE() to GMT', then that will imply some math, as we have to figure out what time zone you're in, plus based on that time zone (and local considerations such as US-Indiana or US-Arizona does not participate in Daylight Savings Time) whether or not you are in DST and therefore need to add/subtract an hour.

As long as Daylight Savings Time is not a problem (and if what you really want is UTC, not GMT), the following may help:

SELECT DATEADD(SECOND,-(DATEDIFF(SECOND,GETDATE(),GETUTCDATE()),GETDATE())

Select allOpen in new window

JimHorn solution will work, but only if GMT time is four hours ahead (which can be not always true).

If you want to get the current GMT time, just use the function GETUTCDATE():

SELECT GETUTCDATE();

Select allOpen in new window

Hope this helps. Regards.

all good.. but like my sample I need just the time in 24hr format

Define 'in 24hr format '.  This article is a real good cheat sheet for date formats.