| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Amir Tahvildaran <amir(at)mathforum(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Custom DateStyle |
| Date: | 2005-07-20 15:40:47 |
| Message-ID: | 20050720154047.GA28775@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jul 19, 2005 at 11:51:55 -0400,
Amir Tahvildaran <amir(at)mathforum(dot)org> wrote:
> Is it possible to add a custom datestyle?
>
> I am migrating from sybase to postgres and the datetime/timestamp
> formats are different, some of the existing code depends on that
> format. I thought the easiest way would be to use a custom datestyle,
> but I couldn't find out how to add one (if thats possible). Does anyone
> have any better ideas?
You can use to_char to convert dates to strings in custom formats.
That may do what you want.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Caduto | 2005-07-20 15:47:52 | Re: Quotation marks in queries |
| Previous Message | Tony Caduto | 2005-07-20 15:30:34 | Re: Quotation marks in queries |