StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16805921
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-05-29T05:08:49.320
FavoriteCount
0
LastActivityDate
2013-05-29T06:36:02.960
LastEditDate
2013-05-29T06:36:02.960
LastEditorUserId
2351011
OwnerUserId
2351011
ParentId
16805762
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I wrote a static utility method that you can just drop in and use...and hopefully it is clear enough to demonstrate the proper use of the SimpleDateFormat parse() and format() methods: <pre><code> /** * Returns a reformatted version of the input date string, where the format * of the input date string is specified by dateStringFormat and the format * of the output date string is specified by outputFormat. Format strings * use SimpleDateFormat format string conventions. * * @param dateString input date string * @param dateStringFormat format of the input date string (e.g., dd/MM/yyyy) * @param outputFormat format of the output date string (e.g., MMM dd, yyyy) * * @return reformatted date string * * @throws ParseException if an error occurs while parsing the input date * string using the provided format * * @author Steve */ public static final String reformatDateString(final String dateString, final String dateStringFormat, final String outputFormat) throws ParseException { final SimpleDateFormat dateStringParser = new SimpleDateFormat(dateStringFormat); final SimpleDateFormat outputFormatter = new SimpleDateFormat(outputFormat); return outputFormatter.format(dateStringParser.parse(dateString)); } </code></pre> You call it as follows: <pre><code> System.out.println(reformatDateString("2013-5-28", "yyyy-MM-dd", "dd/MMM/yyyy")); </code></pre> Which, in this example, will output this: <pre><code> 28/May/2013 </code></pre> The basic idea is that you generally use a SimpleDateFormat instance for one of two things: <ol> <li>To convert a String containing a date with a known format to a java.util.Date instance...using the parse() method, or</li> <li>To convert a java.util.Date instance to a String of a specified format...using the format() method.</li> </ol> I am doing both in one line in the method that I wrote using the two different SimpleDateFormat instances that I create in that method - one created using the input format (for parsing the original String into a Date instance)...and one created using the output format (for converting the created Date back into a String with the desired format).
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POChange date format
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USsteve
UserOwnerUserId
1. USsteve
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.