date and time+ mysql

Hello all

I use a script which in some parts generates date , exactly with such format :

Aug-4-2007 09:05:23 PM

I searched inside the script to find any php date format like ('D M d, Y g:i a')
which generates Aug-4-2007 09:05:23 PM but I didnt find ,

something that I found is now(); from mysql,
1-How can I change this format?
2-I omite the time from date ?

Thanks all :) (im not a php coder :o )

there are mysql functions out there to format a date, what does now() return?

there are mysql functions out there to format a date, what does now() return?

it returns date and time
Aug-4-2007 09:05:23 PM
I need the date in different format also the time,

I changes all now() to CURDATE() but the returns didnt change

The php code below is = to August 4, 2007. Check the php manual - or a book - for more date and time functions.
date('F j, Y');

To format dates with DATE_FORMAT() from a MySQL database the input has to be YYYY-MM-DD HH:MM:SS

The php code below is = to August 4, 2007. Check the php manual - or a book - for more date and time functions.
date('F j, Y');

To format dates with DATE_FORMAT() from a MySQL database the input has to be YYYY-MM-DD HH:MM:SS

There is no date format in all script, only now() function

so change now so that you use DATE_FORMAT along with NOW(). by the way NOW will not output the date in the way you have shown it will only output yyyy-mm-dd hh:mm:ss and no other format unless you use date_format

show us your acutal code in that part of the script rather than us guessing.