You are right!
I am doing something wrong? I understand that there is a difference but I don't know why.
mex2=# select
mex2-# age(endeddatetime,starteddatetime),
mex2-# time,
mex2-# date_part('second',(age(endeddatetime,starteddatetime)))*1000,
mex2-# date_part('second',(age(endeddatetime,starteddatetime)))*1000-time as Must_be_Zero,
mex2-# date_part('second',((starteddatetime)))*1000 as starteddatetime_s,
mex2-# date_part('second',((endeddatetime)))*1000 as endeddatetime_s,
mex2-# starteddatetime,
mex2-# endeddatetime
mex2-# from entry where not date_part('second',(age(endeddatetime,starteddatetime)))*1000=time;
age | time | ?column? | must_be_zero | starteddatetime_s | endeddatetime_s | starteddatetime | endeddatetime
--------------+------+----------+-----------------------+-------------------+-----------------+----------------------------+----------------------------
00:00:04.031 | 4031 | 4031 | -4.54747350886464e-13 | 51171 | 55202 | 2004-05-10 12:47:51.171-05 | 2004-05-10 12:47:55.202-05
00:00:04.094 | 4094 | 4094 | 4.54747350886464e-13 | 51171 | 55265 | 2004-05-10 12:47:51.171-05 | 2004-05-10 12:47:55.265-05
00:00:04.047 | 4047 | 4047 | -4.54747350886464e-13 | 32781 | 36828 | 2004-05-10 12:50:32.781-05 | 2004-05-10 12:50:36.828-05
00:00:02.047 | 2047 | 2047 | 2.27373675443232e-13 | 54171 | 56218 | 2004-05-10 14:10:54.171-05 | 2004-05-10 14:10:56.218-05
00:00:04.046 | 4046 | 4046 | 4.54747350886464e-13 | 5312 | 9358 | 2004-05-10 14:13:05.312-05 | 2004-05-10 14:13:09.358-05
(5 rows)
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
