From: Dawn Albrecht <oinee@yahoo.com>
To: pgsql-chat@postgresql.org
Subject: New and Timestamp Question
Date: Fri, 15 Aug 2003 04:30:02 -0700 (PDT)
Message-ID: <20030815113002.69121.qmail@web11505.mail.yahoo.com> (raw)
Greets,
I am new to postgres and I'm not even sure if I'm
writing to the correct place but here it goes:
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.
I used the Set datestyle command and no matter what I
set it to, the date itself changes, but not the time
format?
Any suggestions? I will be using the timestamp field
on an ASP and JSP page and I was hoping to just modify
its view in the database itself.
Thank you,
DA
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-chat@postgresql.org
Cc: oinee@yahoo.com
Subject: Re: New and Timestamp Question
In-Reply-To: <20030815113002.69121.qmail@web11505.mail.yahoo.com>
References: <20030815113002.69121.qmail@web11505.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox