Date formats

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 - 06:56:14 CST