StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3546998
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-08-23T11:16:54.117
FavoriteCount
0
LastActivityDate
2010-08-26T08:57:36.777
LastEditDate
2010-08-26T08:57:36.777
LastEditorUserId
102238
OwnerUserId
102238
ParentId
3546905
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
For Net 2.0 and 1.1 you could use the TimeZone class which has now been replaced by the TimeZoneInfo class. Edit after further research It would appear that prior to NET 3.5 all that was available was the TimeZone class. It is not possible to calculate the TimeDate value for timezones other than the local one and UTC. So if you wish to calculate the time as EST or PST and you're based in the UK then things become a little more difficult. Here's a short demo program for using TimeZone (its from a basic console app.: <pre><code>class Program { static void Main(string[] args) { DateTime time = DateTime.UtcNow; Console.WriteLine(string.Format("UTC time is {0}", time.ToShortTimeString())); TimeZone zone = TimeZone.CurrentTimeZone; //The following line depends on a call to TimeZone.GetUtcOffset for NET 1.0 and 1.1 DateTime workingTime = zone.ToLocalTime(time); DisplayTime(workingTime, zone); IFormatProvider culture = new System.Globalization.CultureInfo("en-GB", true); workingTime = DateTime.Parse("22/2/2010 12:15:32"); Console.WriteLine(); Console.WriteLine(string.Format("Historical Date Time is : {0}",workingTime.ToString())); DisplayTime(workingTime, zone); Console.WriteLine("Press any key to close ..."); Console.ReadLine(); } static void DisplayTime(DateTime time, TimeZone zone) { Console.WriteLine(string.Format("Current time zone is {0}", zone.StandardName)); Console.WriteLine(string.Format("Does this time include Daylight saving? - {0}", zone.IsDaylightSavingTime(time) ? "Yes" : "No")); if (zone.IsDaylightSavingTime(time)) { Console.WriteLine(string.Format("So this time locally is {0} {1}", time.ToShortTimeString(), zone.DaylightName)); } else { Console.WriteLine(string.Format("So this time locally is {0} {1}", time.ToShortTimeString(), zone.StandardName)); } Console.WriteLine(string.Format("Time offset from UTC is {0} hours.", zone.GetUtcOffset(time))); } } </code></pre> As you can see it only deals with local time and UTC.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POChange timezone in C#
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USChrisBD
UserOwnerUserId
1. USChrisBD
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.