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