Skip site navigation (1) Skip section navigation (2)

Re: Auto-formatting timestamps?

From: "Mag Gam" <magawake(at)gmail(dot)com>
To: "Peter Koczan" <pjkoczan(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Auto-formatting timestamps?
Date: 2008-05-13 22:54:52
Message-ID: 1cbd6f830805131554o786d15aasdf8f00aeb790043e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
Why not create a view?



On Tue, May 13, 2008 at 11:58 AM, Peter Koczan <pjkoczan(at)gmail(dot)com> wrote:

> Hi all,
>
> I'm undergoing a port from an old Sybase database to Postgres. It's
> going surprisingly well, but I have a question regarding formatting of
> timestamps.
>
> In Sybase, we get:
> :> select date from checkoutdate;
> date
> 'May  1 2001 12:00AM'
> ...
>
> In Postgres:
> => select date from checkoutdate;
>       date
> ---------------------
>  2001-05-01 00:00:00
> ...
>
> I can properly format it using to_char:
> => select to_char(date, 'Mon DD YYYY HH:MIAM') as date from checkoutdate;
>       date
> ---------------------
>  May 01 2001 12:00AM
> ...
>
> Short of creating a wrapper type for timestamp (which seems like
> overkill just for modifying the output function), is there a way to
> output the Sybase format automatically (i.e. without a call to
> to_char)?
>
> I've found some code that actually somewhat depends on this format,
> and one of my goals in this port is to change as little client code as
> possible. Is it possible to automatically change the output like this,
> preferably on a per-connection basis? I found stuff regarding the
> datestyle parameter in the docs, but that doesn't quite do what I'd
> like.
>
> Thanks much,
> Peter
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

In response to

Responses

pgsql-sql by date

Next:From: Gavin 'Beau' BaumanisDate: 2008-05-13 23:54:43
Subject: Add a ROWCOUNT to the output of a select.
Previous:From: Peter KoczanDate: 2008-05-13 15:58:25
Subject: Auto-formatting timestamps?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group