Re: TIME ZONE SQL

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Raman" <ramang(at)smartdatainc(dot)com>, "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: TIME ZONE SQL
Date: 2004-02-04 20:03:07
Message-ID: 200402042003.07189.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wednesday 04 February 2004 17:57, Raman wrote:
>
> This query runs fine when i have
> time_difference value like +5:30 +5:00 i.e. works fine for positive values
> but failes for negative values i.e. -7:00, -6:00 etc
>
> I don't know WHY WHY... pls help
> I am helpless.

Can you give example outputs? It's difficult to decide otherwise.
--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Sydney-Smith 2004-02-05 01:48:21 Slow sub-selects, max and count(*)
Previous Message Raman 2004-02-04 17:57:20 TIME ZONE SQL