date_format

[toddlahman]

I'm trying keep the date, and trim off the time when I pull it from a
wordpress datebase in a while loop. Here's what I'm doing right now:

$lmdate = mysql_query("SELECT post_modified FROM wp_posts WHERE
post_status = 'publish'");

while ($date = mysql_fetch_array($lmdate, MYSQL_ASSOC)) {
$lm = $date['post_modified'];

echo $lm;

My out put is:

2007-10-03 12:55:19

I'd like the output to be just the date without the time:

2007-10-03

Thanks you,

HG

[MikeB]

On Jul 22, 12:01 am, [e-mail] wrote:

I'm trying keep the date, and trim off the time when I pull it from a
wordpress datebase in a while loop. Here's what I'm doing right now:

$lmdate = mysql_query("SELECT post_modified FROM wp_posts WHERE
post_status = 'publish'");

while ($date = mysql_fetch_array($lmdate, MYSQL_ASSOC)) {
$lm = $date['post_modified'];

echo $lm;

My out put is:

2007-10-03 12:55:19

I'd like the output to be just the date without the time:

2007-10-03

Thanks you,

HG

Take the leftmost 10 characters?

[MikeB]

On Jul 22, 12:26 am, MikeB <[e-mail]:

On Jul 22, 12:01 am, [e-mail] wrote:

I'm trying keep the date, and trim off the time when I pull it from a
wordpress datebase in a while loop. Here's what I'm doing right now:

$lmdate = mysql_query("SELECT post_modified FROM wp_posts WHERE
post_status = 'publish'");

while ($date = mysql_fetch_array($lmdate, MYSQL_ASSOC)) {
$lm = $date['post_modified'];

echo $lm;

My out put is:

2007-10-03 12:55:19

I'd like the output to be just the date without the time:

2007-10-03

Thanks you,

HG

Take the leftmost 10 characters?

should have added this:

Check out

http://us3.php.net/manual/en/function.substr.php

[Geoff Berrow]

Message-ID:
<6c**********************************@j33g2000pri. googlegroups.comfrom
to********@gmail.com contained the following:

>My out put is:

2007-10-03 12:55:19

I'd like the output to be just the date without the time:

2007-10-03

I think you need to check out the mySql date formatting functions.

--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011
http://slipperyhill.co.uk

[Suhas Dhoke]

On Jul 22, 10:01*am, [e-mail] wrote:

I'm trying keep the date, and trim off the time when I pull it from a
wordpress datebase in a while loop. Here's what I'm doing right now:

$lmdate = mysql_query("SELECT post_modified FROM wp_posts WHERE
post_status = 'publish'");

while ($date = mysql_fetch_array($lmdate, MYSQL_ASSOC)) {
* * * * * * * * $lm = $date['post_modified'];

* * * * echo $lm;

My out put is:

2007-10-03 12:55:19

I'd like the output to be just the date without the time:

2007-10-03

Thanks you,

HG

You can format the date, by using the date() function of php.

like this..

echo date('Y-m-d', strtotime($lm));

It will output like this.. 2007-10-03.

Cheers..!!!

[Michael Fesser]

..oO(to********@gmail.com)

>I'm trying keep the date, and trim off the time when I pull it from a
wordpress datebase in a while loop. Here's what I'm doing right now:

$lmdate = mysql_query("SELECT post_modified FROM wp_posts WHERE
post_status = 'publish'");

while ($date = mysql_fetch_array($lmdate, MYSQL_ASSOC)) {
$lm = $date['post_modified'];

echo $lm;

My out put is:

2007-10-03 12:55:19

I'd like the output to be just the date without the time:

2007-10-03

Use MySQL's DATE() function.

Micha