Date formats

From: Matty <matt_at_slippeddisk.fsnenegspamt.co.uk>
Date: Sun, 23 Feb 2003 12:56:14 -0000
Message-ID: <b3agdf$uq$1_at_newsg1.svr.pol.co.uk>



[Quoted] Hi all.

[Quoted] 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 - 13:56:14 CET

Original text of this message