DateTime

's Computer Specifications

Hello,

I am inserting records on the database and I want to insert the
current date and time.

I don't know where the web site will be hosted and I always want to
display the date time in the timezone of the user.

Shouldn't I insert the data time in the database always using
something like UTC or Greenwish? How I do this?

And when I retrieve it how can I display it in the timezone fo the
user visiting the web site?

Thanks,

Miguel

's Computer Specifications

Did you find a solution?

"shapper" wrote:

> Hello,
>
> I am inserting records on the database and I want to insert the
> current date and time.
>
> I don't know where the web site will be hosted and I always want to
> display the date time in the timezone of the user.
>
> Shouldn't I insert the data time in the database always using
> something like UTC or Greenwish? How I do this?
>
> And when I retrieve it how can I display it in the timezone fo the
> user visiting the web site?
>
> Thanks,
>
> Miguel
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Millisecond values missing when inserting datetime into datetime column of sql Server	Manikandan	Microsoft C# .NET	4	18th Jul 2007 08:59 PM
How can I save a DateTime from my C# program into a SQL Server (datetime) database column.	Steve Kershaw	Microsoft ASP .NET	5	29th Aug 2006 03:10 AM
System.DateTime doesn't convert to SqlDbType.DateTime	Narshe	Microsoft C# .NET	3	2nd Nov 2005 05:42 PM
DateTime problem: how to create datetime format hh:mm:ss AM/PM without the date	mimi	Microsoft C# .NET	1	6th Aug 2004 08:28 PM
XML dateTime conversion to DateTime.MinValue accross timezones	Symon R	Microsoft Dot NET	0	6th Aug 2003 07:50 AM