469,658 Members | 1,855 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

How to manipulate date?

If I have a date that looks like: 2005-12-07 10:10:00

How could I manipulate it in php to say "Dec, 07, 2005"?

I can separate the string at the space, but don't know where to go from
there....thanks for any suggestions.

Dec 8 '05 #1
5 2577
*** Greg Scharlemann escribió/wrote (7 Dec 2005 17:46:43 -0800):
If I have a date that looks like: 2005-12-07 10:10:00

How could I manipulate it in php to say "Dec, 07, 2005"?


I think it easier to just get the date in unix timestamp format rather than
a string. Afterwards, you can use several PHP date functions to display it,
such as date() or strftime().

I suppose it comes from a MySQL query so try this:

SELECT UNIX_TIMESTAMP(date_field) FROM table
--
-+ Álvaro G. Vicario - Burgos, Spain
++ http://bits.demogracia.com es mi sitio para programadores web
+- http://www.demogracia.com es mi web de humor libre de cloro
--
Dec 8 '05 #3
Greg Scharlemann wrote:
If I have a date that looks like: 2005-12-07 10:10:00

How could I manipulate it in php to say "Dec, 07, 2005"?

I can separate the string at the space, but don't know where to go from
there....thanks for any suggestions.

Here's a method I've used (found it using Google a year or so ago):

$a = '2005-12-07';

$y = $a[0].$a[1].$a[2].$a[3];
$m = $a[5].$a[6];
$d = $a[8].$a[9];
$unixtimestamp = mktime(0, 0, 0, $m, $d, $y);

$display_date = date('F j, Y',$unixtimestamp)

--
*****************************
Chuck Anderson • Boulder, CO
http://www.CycleTourist.com
Integrity is obvious.
The lack of it is common.
*****************************
Dec 8 '05 #4
Greg Scharlemann wrote:
If I have a date that looks like: 2005-12-07 10:10:00

How could I manipulate it in php to say "Dec, 07, 2005"?

I can separate the string at the space, but don't know where to go from
there....thanks for any suggestions.


$unixTimestamp = strtotime ("2005-12-07 10:10:00") ;
echo date("M, d, Y", $unixTimestamp);
Dec 9 '05 #5
NC
Greg Scharlemann wrote:

If I have a date that looks like: 2005-12-07 10:10:00

How could I manipulate it in php to say "Dec, 07, 2005"?


echo date('M d, Y', strtotime('2005-12-07 10:10:00'));

Cheers,
NC

Dec 9 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Kyle Ramsey | last post: by
8 posts views Thread by Paul | last post: by
3 posts views Thread by Isaac Rodriguez | last post: by
3 posts views Thread by Stewart | last post: by
1 post views Thread by Andreas Palm | last post: by
1 post views Thread by jayanthigk2004 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.