StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20282855
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-29T09:52:49.363
FavoriteCount
0
LastActivityDate
2013-11-29T09:52:49.363
LastEditDate
LastEditorUserId
0
OwnerUserId
1172862
ParentId
20282023
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
You can create your own custom format provider to get this specific dateformat "Friday Nov 29th 2013" <pre><code>public class SuffiexFormattedDateProvider : IFormatProvider, ICustomFormatter { /// <summary> /// Returns an object that provides formatting services for the specified type. /// </summary> /// <param name="formatType">An object that specifies the type of format object to return.</param> /// <returns> /// An instance of the object specified by <paramref name="formatType" />, if the <see cref="T:System.IFormatProvider" /> implementation can supply that type of object; otherwise, null. /// </returns> public object GetFormat(Type formatType) { if (formatType == typeof(ICustomFormatter)) return this; return null; } /// <summary> /// Converts the value of a specified object to an equivalent string representation using specified format and culture-specific formatting information. /// </summary> /// <param name="format">A format string containing formatting specifications.</param> /// <param name="arg">An object to format.</param> /// <param name="formatProvider">An object that supplies format information about the current instance.</param> /// <returns> /// The string representation of the value of <paramref name="arg" />, formatted as specified by <paramref name="format" /> and <paramref name="formatProvider" />. /// </returns> /// <exception cref="System.NotSupportedException"></exception> public string Format(string format, object arg, IFormatProvider formatProvider) { if (!(arg is DateTime)) throw new NotSupportedException(); var dt = (DateTime)arg; string suffix; if (dt.Day % 10 == 1) { suffix = "st"; } else if (dt.Day % 10 == 2) { suffix = "nd"; } else if (dt.Day % 10 == 3) { suffix = "rd"; } else { suffix = "th"; } return string.Format("{0:dddd MMM} {1}{2}, {0:yyyy}", arg, dt.Day, suffix); } } </code></pre> Then you can use this as <pre><code>string formatDateString = string.Format(new SuffiexFormattedDateProvider(), "{0}", DateTime.Now); </code></pre> Output:- "Friday Nov 29th, 2013"
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POhow to get a custom dateTime format string in c#
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRamashankar
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. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.