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.
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 left. Could anyone suggest as to how to overcome this particular problem.
Thanx in advance,
Unni
