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

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: 2003-08-15 16:31:10
Message-ID: 20030815163110.GA10617@wolff.to (view raw or flat)
Thread:
Lists: pgsql-chat
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.

In response to

Responses

pgsql-chat by date

Next:From: Bruno Wolff IIIDate: 2003-08-18 16:14:40
Subject: Re: New and Timestamp Question
Previous:From: Dawn AlbrechtDate: 2003-08-15 11:30:02
Subject: New and Timestamp Question

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