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!
Welcome to the nuBuilder Forums!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
DATE MANIPULATION
Re: DATE MANIPULATION
at_rcc,
Is this what you're looking for?
SELECT DATE_FORMAT( '2009-10-04 22:23:00', '%Y-%m-%d' )
Steven
Is this what you're looking for?
SELECT DATE_FORMAT( '2009-10-04 22:23:00', '%Y-%m-%d' )
Steven
A short post is a good post.