Home > mailing lists

Re: if else query help - Mailing list pgsql-sql

From	John McKown
Subject	Re: if else query help
Date	October 12, 2000 17:35:17
Msg-id	Pine.LNX.4.21.0010121335580.11424-100000@linux2.johnmckown.net Whole thread Raw
In response to	Re: if else query help (Jean-Christophe Boggio <cat@thefreecat.org>)
List	pgsql-sql

Tree view

On Thu, 12 Oct 2000, Jean-Christophe Boggio wrote:

<snip>
> portion of the day (although I don't know --yet-- how to convert
> date2-date1 to an integer, trunc does not work).


reltime(date2-date1)::int

Will subtract date1 from date2, then cast it to an integer.

John

pgsql-sql by date:

From: Jie Liang
Date: 12 October 2000, 17:25:15
Subject: Re: Standard syntax?

From: Peter Eisentraut
Date: 12 October 2000, 17:42:08
Subject: Re: Standard syntax?

Re: if else query help - Mailing list pgsql-sql

Previous

Next