Posted By

realpeterz on 03/12/11

Tagged

mysql
php

Versions (?)

Last Edited at 03/12/11 04:34am

Statistics

Viewed 846 times

Favorited by 0 user(s)

Related snippets

Mysql Timestamp to PHP data

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

echo date("F j, Y g:i a", strtotime($row["date"]));                  // October 5, 2008 9:34 pm
echo date("m.d.y", strtotime($row["date"]));                         // 10.05.08
echo date("j, n, Y", strtotime($row["date"]));                       // 5, 10, 2008
echo date("Ymd", strtotime($row["date"]));                           // 20081005
echo date('\i\t \i\s \t\h\e jS \d\a\y.', strtotime($row["date"]));   // It is the 5th day.
echo date("D M j G:i:s T Y", strtotime($row["date"]));               // Sun Oct 5 21:34:02 PST 2008