querying Date as month name ?

Mark_Nordstrom

Ok the date is 2003-28-11

I want it to be November, 28th 2003

I was looking in MYSQL and could not find a dam thing that worked with MYSQL version 4.0.15 Standard. So plz dont give me the link to mysql unless you can point out where it is in there.

Shrike

Yep the MySQL date functions were added in a later release. Inside of PHP use

date("F, jS Y", strtotime("2003-28-11"));

http://uk2.php.net/manual/en/function.date.php

Mark_Nordstrom

so if the query is <?php echo $row_g['date']; ?> what would i add to make it quey like i want ?

Weedpacket

Okay; thirty seconds' native intelligence.

I've got a string in $row_g['date']. When I echo it it outputs "2003-28-11". What does [man]date[/man] produce? Oh, a string in the specified format. So when I echo that it should output the string in the format I want.

Now, how to I get $row_g['date'] into bit of code I was given? Um, what's this bit "2003-28-11" there?

...

Actually, the code won't work because your date is in too unconventional a format (strtotime() would have expected "2003-11-28"). You'll need to use explode() to get the year, day and month separately. Then you can use mktime() to build a timestamp out of them that you can give to date() to format for you.

These extra contortions are a side-effect of not using the data types available: MySQL could have done it easily if you'd stored the date as a date...

Mark_Nordstrom

it is 2003-11-28 I mistated it must of been me thinking to fast lol.

Mark_Nordstrom

I got it guys thanks for help.

<?php echo date("F, jS Y", strtotime($row_g['date'])); ?>

Weedpacket

Originally posted by Mark Nordstrom
it is 2003-11-28 I mistated it must of been me thinking to fast lol.

"It is 2003-11-28. I mis-stated. It must have been me thinking too fast. LOL."

I guess that's your theory, and as such it's valid...

Shrike

Heh didn't pick up on that one. strtotime() tries to get too clever when the date format is not what it expects. The first date translates into April, 11th 2005 (2003-12-11 + 26 months)

🙂

I prefer GSV Attitude Adjuster, thats just me though 😉