SQL server - switch to local time (do not use UTC)

I am developing a web project that uses ASP.NET, C#.
We use membership feature for user maintenance.
membership tables seem to store all UTC datetime.
Is there a switch or a property somewhere that will make SQL server to use local server time.
Who is Participating?
BrandonGalderisiConnect With a Mentor Commented:
SQL server keeps track of both local and UTC time.  It is up to the data consumer (the application) to interpret UTC as local time.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.