Solved

local and server dates, timezones

Posted on 2014-03-12
2
145 Views
Last Modified: 2014-03-13
Hi Experts,

We have a web application that intensively uses dates and times. These dates are managed using javascript (client side) and vb.net (server side) then stored in a sqlserver 2008 database.  We would like to store these dates in a ‘standard’ way.  I mean, (1) converting client date to server date or (2) saving dates independently of server or client time zone.  Also, we want the ability to render these dates on the local time zone of the browser.  What is the best and simple way to achieve this?

Thank You,
0
Comment
Question by:KnowledgeWare
2 Comments
 
LVL 33

Accepted Solution

by:
paulmacd earned 500 total points
ID: 39924411
There won't be one right answer to this question so you'll have to find your own way, ultimately.  That said, we convert client and server times to UTC, and save those along with the timezone offset for each.
0
 

Author Closing Comment

by:KnowledgeWare
ID: 39926882
It points me in the right direction
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 5 115
SQL Server RDS clr assembly 4 36
SQL Connection (Error 18456) 14 32
add 1 to a field for 100 rows 11 12
If I have to fix slow responding website my first thoughts are server side optimizations: the database may not be optimized or caching is not enabled, or things like that. We often overlook another major part of our web application: the client. We o…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now