Postgres Pro
Downloads
Home   >   mailing lists

Re: Date/Time Conversion - Mailing list pgsql-sql

From Yasir Malik
Subject Re: Date/Time Conversion
Date
Msg-id Pine.NEB.4.60.0504030943400.21071@pink-elephant.cs.stevens-tech.edu
Whole thread Raw
In response to Re: Date/Time Conversion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: "Sean Davis"
Date:
Subject: Re: a very big table
Next
From: Oleg Bartunov
Date:
Subject: Re: How to store directory like structures?