Re: Date formats

"Matty" <matt_at_slippeddisk.fsnenegspamt.co.uk> kirjoitti viestissä news:b3agdf$uq$1_at_newsg1.svr.pol.co.uk...
> Hi all.
>
> Just a quickie.... how do I change from one default date format (i.e.
> dd-mm-yy) to a desired format (mm/dd/yy) when writing the query.
>
> i.e
>
> SELECT emp.ENAME, emp.HIREDATE
> FROM emp
>
> I cannot seem to find much reference to this anywhere.

I think what you need is DATE_FORMAT function. Found from the mysql manual:

http://www.mysql.com/doc/en/Date_and_time_functions.html Received on Sun Feb 23 2003 - 17:06:14 CET