Last post Sep 12, 2007 03:00 AM by mvark
Sep 12, 2007 02:42 AM|satyaprakash.k|LINK
Is there any possibility to know the client system's date & time format from asp.net(with-out any activeX or other additional supported tools)?.. i got this doubt because the clients can access the web pages across the world so, i want to display a date
time data from the database to client page as client's date-time format. i mean a client accessing from US can get mm/dd/yyyy format and a client accessing same page from India can get dd/mm/yyyy format on the web page.
Sep 12, 2007 03:00 AM|mvark|LINK
If you are concerned not just with the formatting but also want to show the actual date/time with respect to the user (as Indian Standard Time if it is India rather than the US server time), like FeedBurner does, consider storing the date in UTC (Coordinated
To generate a timestamp as UTC with Sql Server, use the GETUTCDATE() function instead of GETDATE ( ) & in C# you can use DateTime.UtcNow