best timing!

[Jassim Rahma]

Hi, I have a post or forum website in ASP.NET and MySQL backend. I want to know what's the best option to save the post's creation time as different people from different countries will access it and it's no proper to show all the EST or GMT time. what's your suggestion?

Technology News @ www.JassimRahma.com

[Sandeep Mewara]

I would save it as a UTC in database. Later convert into Local time in my application based on the people using it.

Sandeep Mewara Microsoft ASP.NET MVP 2012 & 2013 [My Blog]: Sandeep Mewara's Tech Journal! [My Latest Article]: HTML5 Quick Start Web Application

[wikizhao]

var d = new Date(); var localZone = d.getTimezoneOffset()/60;

[kutynko]

Just wanted to add that when a user submits a post you should from javascript take current time, convert it to UTC and pass it to the server. And for another user reading this post you receive UTC time from DB, pass it to the client and in javascript convert it to local time. Because client creating a post, web app host, DB server and another client reading the post may all be in different time zones :)

[wikizhao]

<script> function ss() { $("#date").text( Date()); } </script> use span and give an id ,name is date. id="date" <input id="Button1" type="button" value="button" onclick="ss()" />