Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql time_stamp format
- $mydate = DATEFORMAT(columnName, %b-%D-%Y);
- $query = "SELECT comment, DATE_FORMAT(postdate, '%b %D %Y') FROM sessionscomments WHERE session = 'Geoarge'";
- $result = mysql_query($query);
- while($row = mysql_fetch_assoc($result))
- {
- echo "<div id=fav>";
- echo strip_tags( "Date: {$row['postdate']}");
- SELECT DATE_FORMAT(columnName, '%b %D %Y') AS my_date
- FROM tableName;
- $my_date = date('M jS Y', $timestamp);
- DATE_FORMAT(columnName, '%b %D %Y')
- SELECT someColumn, anotherColumn, DATE_FORMAT(dateColumn, '%b %D %Y') AS formattedDate
Add Comment
Please, Sign In to add comment