Declare @local_date	datetime
Declare @utc_date	datetime
Declare @timezone_id	int

Select @local_date = '2007/7/17 18:43:22.118'

Select @timezone_id  = 7

Select @utc_date	= dbo.F_LOCAL_TO_UTC_DATETIME( @local_date, @timezone_id ) 

Select @local_date	= dbo.F_UTC_TO_LOCAL_DATETIME(   @utc_date, @timezone_id )

select	timeZoneOffset = datediff(hour, getdate(), getutcdate())
	,myDateTime = @myDateTime

DECLARE 
  @DueDateTime datetime, @Clienttime datetime, @Servertime datetime

SET @DueDateTime = '2005-07-01 12:00:00'
SET @Clienttime = '2005-06-14 15:00:00'
SET @Servertime = '2005-06-14 18:00:00'

SELECT DATEADD(hh, DATEDIFF(hh, @Clienttime, @Servertime), @DueDateTime)

quote:

---

Originally posted by Lumbago

I might be totally off here but isn't it possible for you to send the current timestamp from the client to the server? By doing that you would be able to do a DATEDIFF between the clients timestamp and GETDATE() from the server and it would give you the offset in hours. Having that you would be able to tell what timezone the client is in relative to the server and you could just add the offset...here's an example:

DECLARE 
  @DueDateTime datetime, @Clienttime datetime, @Servertime datetime

SET @DueDateTime = '2005-07-01 12:00:00'
SET @Clienttime = '2005-06-14 15:00:00'
SET @Servertime = '2005-06-14 18:00:00'

SELECT DATEADD(hh, DATEDIFF(hh, @Clienttime, @Servertime), @DueDateTime)

Hm...when writing this it almost seems to simple to solve your problem, but from what I can understand from the description of your problem it could be useful (given that it doesn't take an hour to get the data from the client to the server and that daylight savings time changes on the same days throughout the different places). Hm. let's hope I'm not making a fool of myself

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

---