sql and php date( ) help

mfacer

Hi,
I have an entry in my database using the time() method...

what I need to do is to query the table but get results based on the date of the month....

how to I change the SQL statement to do this?
eg:

SELECT * FROM table WHERE date = " . date("M",time()) . "

obviously the date in the database is a number like 14432575 as I used the time() function when the record was written....

thanks for any help 🙂

visualAd

So, am I right in thinking you would like a to get all records in a specified range for a given month. e.g: for september 2004 (1/9 - 30/9)?

discostudio

Initially, I just need to be able to reformat a date that is shown to the customer, in their account.

When I take it out of the database it looks like this:

04-10-2004

And I want to display it to the customer like so:

4th October, 2004

also I want to display the date, somewhere else in the site, like this:

04/09/2004

I know this info is probably available on php.net but asking the pro's is soooo much faster than reding through hours of irrelevant material.

mfacer

Originally posted by visualAd
So, am I right in thinking you would like a to get all records in a specified range for a given month. e.g: for september 2004 (1/9 - 30/9)?

I just basically need to say, "today is 14/10/04" - has the user filled in their time sheet for this day?

so I just need to return a found record or not for the current day.....

discostudio - try http://uk.php.net/manual/en/function.date.php - it's all there....

Thora_Fan

Your best bet is to use the MySQL Date/Time functions...there's a plethora of them and they're pretty handy.

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html