From: | "Unnikrishnan Menon" <unnikrishnan(dot)menon(at)chennai(dot)transys(dot)net> |
---|---|
To: | "Josh Berkus" <josh(at)agliodbs(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Date Time calculation help |
Date: | 2002-01-22 03:29:35 |
Message-ID: | 002601c1a2f5$06ad4330$e90aa8c0@UNNIKRISHNAN |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Thanx Josh,
This helped solve my problem.
Unni
----- Original Message -----
From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Unnikrishnan Menon" <unnikrishnan(dot)menon(at)chennai(dot)transys(dot)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(at)agliodbs(dot)com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | David Stanaway | 2002-01-22 04:05:45 | Re: Passing a list of pairs to a PL/PGSQL function |
Previous Message | David Stanaway | 2002-01-22 02:56:04 | Re: Passing a list of pairs to a PL/PGSQL function |