Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why aren't these queries the same?
> I did confirm that trunc(sysdate) returned the same value as sysdate and
> trunc(scott.table_a.mod_date) returned the same value as
scott.table_a.mod_date.
Ed,
trunc(sysdate) does not return the same value as sysdate. I think the reason that it looks the same when you checked it is because your default date format does not show hours minutes and seconds.
Trunc(sysdate) = midnight
sysdate = right now.
-John Received on Thu Mar 07 2002 - 11:37:18 CST