Re: Time Formats

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jeffery L Post <postjeff(at)uwm(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Time Formats
Date: 2001-01-12 20:45:28
Message-ID: 20010112144528.A23424@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 12, 2001 at 02:02:28PM -0600,
Jeffery L Post <postjeff(at)uwm(dot)edu> wrote:
> Is there any way to have a time datatype returned in various formats?
>
> ex. 1:30 PM
>
> Maybe by setting a session variable?

You can use to_char in a query to convert a date and/or time into a character
string in the format you want.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-12 20:49:36 FreeBSDers paying attention? (was Re: exit status 26)
Previous Message Dan Moschuk 2001-01-12 20:40:03 Re: exit status 26