Looks like this is what I am after.
Current GMT Time = #createODBCTime(VARIABLES.newTime)#
Thanks, Mark
_
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Friday, July 02, 2004 2:35 PM
To: CF-Talk
Subject: RE: Posting to db as GMT date/time
We'll I'm still bangi
> 1) How do I code the date as GMT for insertion to SQL 2000
getUTCDate().
> 2) How to I create the time difference for Ohio?
dateDiff or see this:
http://www.sustainablegis.com/projects/tz/testTZCFC.cfm
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
33 PM
cast from UTC :: 02-Jul-04 06:33 AM
cast to server :: 02-Jul-04 03:33 PM
cast from server :: 02-Jul-04 11:33 AM
(I guess)
Thanks, Mark
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, July 02, 2004 1:46 PM
To: CF-Talk
Subject: RE: Posting to db as GMT
ate
output.
-Novak
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Friday, July 02, 2004 9:41 AM
To: CF-Talk
Subject: RE: Posting to db as GMT date/time
Thanks for your insight.
Thanks, Mark
_
From: Ian Potts [mailto:[EMAIL PROTECTED]
Sent: Friday, July 02, 200
Thanks for your insight.
Thanks, Mark
_
From: Ian Potts [mailto:[EMAIL PROTECTED]
Sent: Friday, July 02, 2004 11:47 AM
To: CF-Talk
Subject: Re: Posting to db as GMT date/time
Sounds like a solid plan to me. Adjust to GMT on insert, display in
whatever timezone you like. I believe the
Sounds like a solid plan to me. Adjust to GMT on insert, display in
whatever timezone you like. I believe the function GetTimeZoneInfo()
will return a struct with the server's offset info.
1) Convert the date from whatever timezone to GMT (use the server's offset).
2) Display using the offset for
6 matches
Mail list logo
