StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4003499
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-10-23T10:23:20.837
FavoriteCount
0
LastActivityDate
2010-10-23T10:33:28.020
LastEditDate
2010-10-23T10:33:28.020
LastEditorUserId
481452
OwnerUserId
481452
ParentId
4003476
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
text
Body
Try to use this class: I defined some constans to translate to spanish but you can ignore those or make the validation language for the others functions!! You can focus on the functions: shortDateHuman(), longDateHuman(), shortTimeHuman(), longTimeHuman() In order to use it you can do: <code>$datetest=new Date($language);</code> and then use <code>$datetest->longDateHuman();</code> In addition, you can check the function setGMTOffset if you need it. <pre><code>class Date { var $gmtoffset; var $year; var $month; var $day; var $hour; var $minute; var $second; var $idioma; function Date($lang) { //setlocale (LC_TIME,en_US); list($this->year, $this->month, $this->day) = split("-", gmdate("Y-m-d")); list($this->hour, $this->minute, $this->second) = split(":", gmdate("g:i:s")); $this->gmtoffset = 0; $this->idioma=$lang; } function getYear() { return $this->year; } function setYear($year) { $year = intval($year); if($year >= 0) { $this->year = $year; } else { //throw new Exception("Invalid year! Prior to 0 A.D.!"); } return true; } function getMonth() { return $this->month; } function setMonth($month) { $month = intval($month); if(($month >= 1) && ($month <= 12)) { $this->month = $month; } else { //throw new Exception("Invalid month! Not between 1 and 12!"); } return true; } function getDay() { return $this->day; } function setDay($day) { $day = intval($day); if(($day >= 1) && ($day <= 31)) { $this->day = $day; } else { //throw new Exception("Invalid day! Not between 1 and 31!"); } return true; } function getHour() { return $this->hour; } function setHour($hour) { $hour = intval($hour); if(($hour >= 0) && ($hour <= 23)) { $this->hour = $hour; } else { //throw new Exception("Invalid hour! Not between 0 & 23!"); } return true; } function getMinute() { return $this->minute; } function setMinute($minute) { $minute = intval($minute); if(($minute >= 0) && ($minute <= 59)) { $this->minute = $minute; } else { //throw new Exception("Invalid minute! Not between 0 and 59!"); } return true; } function getSecond() { return $this->second; } function setSecond($second) { $second = intval($second); if(($second >= 0) && ($second <= 59)) { $this->second = $second; } else { //throw new Exception("Invalid second! Not between 0 and 59!"); } return true; } function getGMTOffset() { return $this->gmtoffset; } function setGMTOffset($gmtoffset) { $gmtoffset = intval($gmtoffset); if(($gmtoffset >= -12) && ($gmtoffset <= 12)) { $this->gmtoffset = $gmtoffset; } else { //throw new Exception("Invalid GMT offset! Not between -12 and 12!"); } return true; } function setDate($year, $month, $day) { $this->setYear($year); $this->setMonth($month); $this->setDay($day); return true; } function setTime($hour, $minute, $second, $gmtoffset = 0) { $this->setHour($hour); $this->setMinute($minute); $this->setSecond($second); $this->setGMTOffset($gmtoffset); return true; } function setDateTime($year, $month, $day, $hour, $minute, $second, $gmtoffset) { $this->setDate($year, $month, $day); $this->setTime($hour, $minute, $second, $gmtoffset); return true; } function timestamp() { # This function returns a user's correct timezone in the form # of a unix timestamp. return mktime($this->hour + $this->gmtoffset, $this->minute, $this->second, $this->month, $this->day, $this->year); } function longDateTimeHuman() { # Returns a date string like "Saturday, November 5, 2005 3:25 PM". return date("l, j F, Y g:i A", $this->timestamp()); } function diaSemana(){ # Returns a day string like "Saturday". return date("l", $this->timestamp()); } function mes(){ # retorna un string del mes "November". return date("F", $this->timestamp()); } function diaSemana_es($diaen){ switch($diaen) { case "Saturday": return("Sábado");break; case "Sunday": return("Domingo");break; case "Monday": return("Lunes");break; case "Tuesday": return("Martes");break; case "Wednesday": return("Miércoles");break; case "Thursday": return("Jueves");break; case "Friday": return("Viernes");break; } } function mes_es($mesen){ switch($mesen) { case "January": return(_JAN);break; case "February": return(_FEB);break; case "March": return(_MAR);break; case "April": return(_APR);break; case "May": return(_MAY);break; case "June": return(_JUN);break; case "July": return(_JUL);break; case "August": return(_AUG);break; case "September": return(_SEP);break; case "October": return(_OCT);break; case "November": return(_NOV);break; case "December": return(_DEC);break; } } function longDateHuman() { # Returns a date string like "Saturday, November 5, 2005". if($this->idioma=="en") return date("l, j F , Y", $this->timestamp()); else { return "".$this->diaSemana_es($this->diaSemana()).", ".$this->mes_es($this->mes())." ".$this->day.", ".$this->year; } } function shortDateHuman() { # Returns a date string like "November 5, 2005". return date("F j, Y", $this->timestamp()); } function longTimeHuman() { # Returns a time like "3:32:56 PM". F j of Y, g:i a return date("g:i:s A", $this->timestamp()); // return date("F j of Y", $this->timestamp()); } function shortTimeHuman() { # Returns a time like "3:32 PM". return date("g:i A", $this->timestamp()); } function militaryTime() { # Returns a time like "15:34:24". return date("h:i:s", $this->timestamp()); } function SQLDate() { return date("Y-m-d", $this->timestamp()); } function SQLDate_convertir($timestamp){ // echo date("Y-m-d", $timestamp); // echo $timestamp; // $aux=getdate($timestamp); // $aux=mktime($timestamp); // $aux=gmstrftime($timestamp); //echo // print_r(getdate($timestamp)); // $aux=$timestamp; //$aux=date("Y-m-d", $timestamp); $aux=split(" ",$timestamp); //print_r($aux); return $aux[0]; } function SQLTime() { return date("h:i:s", $this->timestamp()); } function SQLDateTime() { return date("Y-m-d h:i:s", $this->timestamp()); } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHuman Readable Date Using PHP
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USNervo Verdezoto
UserOwnerUserId
1. USNervo Verdezoto
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHuman Readable Date Using PHP
 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
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThank you so much!
 singulars
 PostPostId
 PO
 UserUserId
 USDenis Bobrovnikov

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.