Re: Re: [HOW TO:] timestamp WITHOUT timezone

Actually you could use the to_char function and do
something like:


processdata=> select to_char(now(), 'YYYY-MM-DD
HH24:MI');
     to_char
------------------
 2001-08-02 13:45
(1 row)

It sometimes can cause confusion to leave timestamps
off, but you can format your timestamps however you
please using to_char.

Good Luck,
Jason

--- Vivek Khera <khera@kcilink.com> wrote:
> >>>>> "CF" == Christophe Faizant
> <cfaizant@prisma-presse.com> writes:
>
> CF> I have the following problem with my postgresql
> "timestamp" type
> CF> field.  I don't wish to get a timezone attribute
> after the
> CF> timestamp, but each time I browsed rows via
> phppgadmin or via my
> CF> php pages, I've gotten an additional
>
> Timestamps always have timezone.  No way around it.
> You need to alter
> your application to deal with it.
>
>
> --
>
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D.                Khera
> Communications, Inc.
> Internet: khera@kciLink.com       Rockville, MD
>  +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera
> http://www.khera.org/~vivek/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/