Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2010-08-18
1
Medium Priority
?
541 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:vu3lmg
1 Comment
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 2000 total points
ID: 33466417
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.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question