StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8823792
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-01-11T17:27:07.667
FavoriteCount
0
LastActivityDate
2012-01-12T09:00:30.770
LastEditDate
2012-01-12T09:00:30.770
LastEditorUserId
162294
OwnerUserId
162294
ParentId
8823632
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Use DATEDIFF <pre><code>SELECT DATEDIFF(month, '2000-02-10','2000-01-10'); </code></pre> yields 1 since 02-10 is one month after 01-10 month can be changed to day to get the number of days instead. Reference: <a href="http://www.1keydata.com/sql/sql-datediff.html" rel="nofollow">http://www.1keydata.com/sql/sql-datediff.html</a> UPDATE: In MSQL you could use DATEDIFF because it can be passed month as an argument, the MySQL version only returns days. In MySQL you could instead use <a href="http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_period-diff" rel="nofollow">PERIOD_DIFF</a>. Although it doesn't know about the exact number of days in each month. <blockquote> PERIOD_DIFF(P1,P2) </blockquote> "Returns the number of months between periods P1 and P2. P1 and P2 should be in the format YYMM or YYYYMM. Note that the period arguments P1 and P2 are not date values." <pre><code>mysql> SELECT PERIOD_DIFF(200802,200703); -> 11 </code></pre> If you need to know if exactly how many months differ you need to make a multistep calculation. To find out the number of days in a month you could use the <a href="http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_last-day" rel="nofollow">LAST_DAY</a> function and from the results extract the day part and use as the basis for further calculations. <pre><code> LAST_DAY('2003-02-05'); -> '2003-02-28' </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to check, if the the current date and other dates are longer than 1 month ago?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USKristofer
UserOwnerUserId
1. USKristofer
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to check, if the the current date and other dates are longer than 1 month ago?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COI tried `DATEDIFF (month, CURRENT_DATE(),c.expires)` but he doesn't like `CURRENT_DATE()`. Do you know what I should put there for the current date?
 singulars
 PostPostId
 PO
 UserUserId
 USVay
2. COI guess you didn't mean MySQL? Because like in the MySQL documentary there are only two expressions allowed. So I can get the days with `DATEDIFF(CURDATE(),c.expires)` but not exactly a month with an output of one. Isn't this anyhow possible to transform it to month in MySQL?
 singulars
 PostPostId
 PO
 UserUserId
 USVay

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.