Re: Date Time calculation help - Mailing list pgsql-sql

From Unnikrishnan Menon
Subject Re: Date Time calculation help
Date
Msg-id 002601c1a2f5$06ad4330$e90aa8c0@UNNIKRISHNAN
Whole thread Raw
In response to Date Time calculation help  ("Unnikrishnan Menon" <unnikrishnan.menon@chennai.transys.net>)
List pgsql-sql
Thanx Josh,

This helped solve my problem.

Unni
----- Original Message ----- 
From: "Josh Berkus" <josh@agliodbs.com>
To: "Unnikrishnan Menon" <unnikrishnan.menon@chennai.transys.net>
Sent: Tuesday, January 22, 2002 2:02 AM
Subject: Re: [SQL] Date Time calculation help


> Unni,
> 
> > I tried the same query in postgresql but the value returned is 0.
> > The query was:
> > select mod((current_date - '2002-15-01')),1);
> 
> The problem above is that you are using the DATE data type, which does
>  not admit hours.  As a result, mod(1)=0 is quite correct.
> 
> You want to use the TIMESTAMP data type, and process your outcome as an
>  interval:
> select (current_timestamp - ('2002-15-01'::Timestamp))
> which should give you some days and some hours.
> 
> See: http://techdocs.postgresql.org/techdocs/faqdatesintervals.php
> for more info about dates and times.
> 
> Of course, I could give you more help if I was clear on what exactly
>  you want to achieve.  Do you want the date, or just hours? Care to
>  elucidate?
> 
> -Josh Berkus
> 
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco



pgsql-sql by date:

Previous
From: David Stanaway
Date:
Subject: Re: Passing a list of pairs to a PL/PGSQL function
Next
From: David Stanaway
Date:
Subject: Re: Passing a list of pairs to a PL/PGSQL function