GetDate and Timezones

[GDX]

Hello Guys,

I am in NY and im making a website that has to operate on EST but the problem is my web server and sql server is located in CA. Is there a function that will work on specific timezones? I know i can just GetDate() - 3 (peusdo code) but is there another solution? Is there another built in function I can rely on in either SQL Server or ASP (Frontend/Webserver)

Thanks a lot,
Gordon

Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[dbomrrsm]

Not sure but this thread may be of some help:

thread183-268507



[blue]DBomrrsm[/blue]