Hi,
I have a field called "Starting DateTime" and I want to convert into my local time. I can convert it in the report with the expression "=System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Starting_DateTime.Value)", but that is too late. I want to convert it in the Select statement of the query.
Can anyone help me please?
Thx
I'm not entirely sure what you're trying to get at, but SQL Server has the following function that will get you the current UTC time:
GETUTCDATE()
If you are trying to convert the time from the timestamp to the corresponding local timestamp value, you would need to know the offset and add this time to the existing field.
Hope this helps some.
Simone
|||Yeah!! That's the solution...... 2 weeks of deep frustrations and just such a simple solution..... wow!
Thx a lot!!! 
No problem, glad it worked for you. If you mark this as the answer it will better help others. Thanks.
Simone
sqlsql
No comments:
Post a Comment