Received: from chennai.transys (chennai.transys.net [12.33.140.105]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0F3vXV33482 for ; Mon, 14 Jan 2002 22:57:34 -0500 (EST) (envelope-from unnikrishnan.menon@chennai.transys.net) Received: from UNNIKRISHNAN ([192.168.10.233]) by chennai.transys with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id CGH4Y5B8; Tue, 15 Jan 2002 09:40:12 +0530 Message-ID: <005e01c19d79$16219db0$e90aa8c0@UNNIKRISHNAN> From: "Unnikrishnan Menon" To: Subject: Date Time calculation help Date: Mon, 14 Jan 2002 20:28:39 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0090_01C19D3A.0CDD0580" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200201/158 X-Sequence-Number: 6244 This is a multi-part message in MIME format. ------=_NextPart_000_0090_01C19D3A.0CDD0580 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have a particular query in Oracle : select mod((sysdate - to_date('15-JAN-02','dd-mon-yy')),1) from dual; The above query gives 0.752.. as the difference between the two days which = when multiplied by 24 gives around 3.1.. hrs.=20 I tried the same query in postgresql but the value returned is 0. The query was: select mod((current_date - '2002-15-01')),1); I require the difference in time to the last second to be shown as time lef= t. Could anyone suggest as to how to overcome this particular problem. Thanx in advance, Unni ------=_NextPart_000_0090_01C19D3A.0CDD0580 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I have a particular query in Oracle :
 
select mod((sysdate -=20 to_date('15-JAN-02','dd-mon-yy')),1) from dual;
The above query gives 0.752.. as the diffe= rence=20 between the two days which when multiplied by 24 gives around 3.1.. hrs.=20
 
I tried the same query in postgresql but t= he value=20 returned is 0.
The query was:
select mod((cu= rrent_date -=20 '2002-15-01')),1);
 
I require the difference in time to the la= st second=20 to be shown as time left. Could anyone suggest as to how to overcome this= =20 particular problem.
 
Thanx in advance,
 
Unni
------=_NextPart_000_0090_01C19D3A.0CDD0580--