472,143 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

Capturing the date and time based on clients timezone in SQL Server 2005

Dear all,

I have struck in one of the different type of requirement in SQL Server 2005.

I need an equivalent functionality of capturing date and time based on client's timezime, as it is possible in Oracle by using LOCALTIMESTAMP() which will capture the session's date and time based on the time zone.

Can anyone get me the solution?
Jul 22 '08 #1
1 1393
2,878 Expert 2GB
I think it's available in SQL2008. Can't you pass it from the client app?

-- CK
Jul 22 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Andrew DeFaria | last post: by
1 post views Thread by praba kar | last post: by
8 posts views Thread by Zvonko | last post: by
9 posts views Thread by ice | last post: by
7 posts views Thread by =?Utf-8?B?U3R1?= | last post: by
2 posts views Thread by =?Utf-8?B?Sm9ubnk=?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.