Hosting server time not in same time zone.

[theevilone]

I need to insert the time of a form submitted by a user, into my SQL server DB. My host is in a different time zone to me by 5 hours. I do n't want to use the client time either, as that would introduce lots of other issues.

How can I :-

a)compensate for the 5 hours, bearing in mind that this may also affect the date, depending on when it is submitted.
b)account for daylight saving ?

Any help would be much appreciated.

 

[tleish]

Use the DateAdd() function:

<cfoutput>#DateAdd(&quot;h&quot;, -5, Now())#</cfoutput> - tleish

 

[theevilone]

Thanks tleish.