Guest User

Untitled

a guest
Aug 18th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. mysql time_stamp format
  2. $mydate = DATEFORMAT(columnName, %b-%D-%Y);
  3.  
  4. $query = "SELECT comment, DATE_FORMAT(postdate, '%b %D %Y') FROM sessionscomments WHERE session = 'Geoarge'";
  5. $result = mysql_query($query);
  6.  
  7. while($row = mysql_fetch_assoc($result))
  8. {
  9.  
  10. echo "<div id=fav>";
  11. echo strip_tags( "Date: {$row['postdate']}");
  12.  
  13. SELECT DATE_FORMAT(columnName, '%b %D %Y') AS my_date
  14. FROM tableName;
  15.  
  16. $my_date = date('M jS Y', $timestamp);
  17.  
  18. DATE_FORMAT(columnName, '%b %D %Y')
  19.  
  20. SELECT someColumn, anotherColumn, DATE_FORMAT(dateColumn, '%b %D %Y') AS formattedDate
Add Comment
Please, Sign In to add comment