Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] formatting dates? - Mailing list pgsql-general

From Sevo Stille
Subject Re: [GENERAL] formatting dates?
Date
Msg-id 389EED8F.6C2BB950@ip23.net
Whole thread Raw
In response to formatting dates?  (Frank R Callaghan <f.callaghan@ieee.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [GENERAL] using ID as a key
Next
From:
Date:
Subject: Re: [GENERAL] using ID as a key(REPOST)