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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: New and Timestamp Question

  • From: Bruno Wolff III <bruno(at)wolff(dot)to>
  • To: Dawn Albrecht <oinee(at)yahoo(dot)com>
  • Cc: pgsql-chat(at)postgresql(dot)org
  • Subject: Re: New and Timestamp Question
  • Date: Fri, 15 Aug 2003 11:31:10 -0500
  • Message-id: <20030815163110(dot)GA10617(at)wolff(dot)to>
On Fri, Aug 15, 2003 at 04:30:02 -0700,
  Dawn Albrecht <oinee(at)yahoo(dot)com> wrote:
> 
> All I want to do is change the timestamp format.  I
> can change the 'date' part of it, but the time is
> always delivered as: 14:00:00 instead of 2:00:00 PM. 
> I do not wish to view army time, but regular
> non-military time.

You can use to_char to get the time in the repsentation you want.
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group