Posted by mpar612 on 08/07/06 12:17

Hello everyone,

I am having some difficulty with the date_format function in MySQL. I
have an 'add_date' column in my database as a timestamp type. This
automatically adds the current date and time when a user submits a
form. I am using PHP and trying to format the date.

I am using the following query:

SELECT isbn, artist_name, album_title, release_date,
date_format(\'add_date\', \'%M %d %Y\'), description, price FROM lounge

When I run this query my date returns null.

If I run the following query, the standard timestamp formatting is
returned:

SELECT isbn, artist_name, album_title, release_date, add_date,
description, price FROM lounge

Am I making an error with my query?

Thanks!

• Next in forum: Re: date_format with MySQL and PHP
• Prev in forum: Re: Entering current date and time into MySQL database using PHP.
• Thread view: date_format with MySQL and PHP

[Reply to this message]