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(at)kcilink(dot)com> wrote:
> >>>>> "CF" == Christophe Faizant
> <cfaizant(at)prisma-presse(dot)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(at)kciLink(dot)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(at)postgresql(dot)org

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