Re: Date/Time Conversion

From: Yasir Malik <ymalik(at)cs(dot)stevens(dot)edu>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Date/Time Conversion
Date: 2005-04-03 03:49:52
Message-ID: Pine.NEB.4.60.0504022247540.14075@dab.cs.stevens-tech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> beta_jgw=# update scenario1.time_test set local_hour = extract(hour from
> to_timestamp(to_char(gmt_date,'YYYY-MM-DD')||'
> '||to_char(gmt_hour,'99')||':00:00-00','YYYY-MM-DD HH24:MI:SS') at time zone
> 'EST'); ^^^^^^^^
>

Wild guess, but shouldn't that be :00:00:00?

Regards,
Yasir

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-04-03 03:50:36 Re: Date/Time Conversion
Previous Message Bruce Momjian 2005-04-03 02:56:34 Re: Query history file