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

[sachinsjoshi]

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?

[ck9663]

I think it's available in SQL2008. Can't you pass it from the client app?

-- CK