MySQL Forums
Forum List  »  Newbie

Re: How to use GET_FORMAT on a query?
Posted by: William Stokes
Date: May 09, 2005 12:17AM

Thanks Felix,

However, this:

"SELECT event_id, name, DATE_FORMAT(date, '%d.%m.%Y'), time, place, type, info
FROM test_table". Won't work???

The date is stored to this table as date(YYYY-MM-DD). This query fetches all other columns but the date. I don't know the cause.

-Will

Options: ReplyQuote


Subject
Written By
Posted
Re: How to use GET_FORMAT on a query?
May 09, 2005 12:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.