nuBuilder Forum

Hi in my customer table ,i have added a field called DATE_CREATED which is of type time_stamp and eventually stores all the details the account was created.

my problem is that i want to extract the date part so that queries can be made such as when did a client registered for my report ! any one an idea? tried the mysql php manual on date still stuck thanks!

at_rcc,

Is this what you're looking for?

SELECT DATE_FORMAT( '2009-10-04 22:23:00', '%Y-%m-%d' )

Steven