Thread: formatting dates?

Excuse my ignorance but is there anyway to
format a returned date aka 'mm/dd/yy' in a query like
sybase dateformat(date, 'mm/dd/yy');
also is the a good document explaining the use
of regex in postgresql.

TIA,
            Frank.

Frank R Callaghan wrote:
>
> Excuse my ignorance but is there anyway to
> format a returned date aka 'mm/dd/yy' in a query like
> sybase dateformat(date, 'mm/dd/yy');

SET DATESTYLE TO 'SQL, US';

Sevo