I created an application in ASP.NET C# and I'm using SQL Server 2012 for my database.
I currently collect the users Date Time from SQL Server using the GetDate() Function. However, the website is hosted in the West Coast while I'm located in the East Coast and it's collecting the entry time in PST instead of EST.
Is there a workaround to this and if so what would be suggested?
Should I remove the GetDate() Function on the SQL Server Database and just collect the current users Date Time in code? If so, what is the best method to collect this in ASP.NET C# code?