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 13:45:49
Message-ID: Pine.NEB.4.60.0504030943400.21071@pink-elephant.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'); ^^^^^^^^
>

This sounds like a stupid answer, but shouldn't that be :00:00:00?

Regards,
Yasir

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Bartunov 2005-04-03 17:00:05 Re: How to store directory like structures?
Previous Message Sean Davis 2005-04-03 12:38:41 Re: a very big table