Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Date formats
Thanks all but sorted it now..
Cheers
Matty
"Matty" <matt_at_slippeddisk.fsnenegspamt.co.uk> wrote in message
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.
>
> Many thanks in advance
>
> Matty
>
>
Received on Sun Feb 23 2003 - 09:48:01 CST