| SitePoint Sponsor |
|
|
User Tag List
Results 1 to 3 of 3
-
Jun 16, 2004, 12:21 #1SitePoint Member
- Join Date
- Oct 2003
- Location
- Portland, Maine
- Posts
- 6
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Format MySQL DateTime value with PHP
Any advice on how to format a MySQL DATETIME value into a more readable string? i.e. 6/16/2004 1:15 pm
-
Jun 16, 2004, 12:38 #2SitePoint Guru
- Join Date
- May 2004
- Location
- santa rosa, ca
- Posts
- 969
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
SELECT UNIX_TIMESTAMP(datefield)
Use the returned value as the 2nd argument of the date function
-
Jun 17, 2004, 03:16 #3SQL Consultant
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
use the mysql DATE_FORMAT function
Bookmarks