Mark

Useful posting this is.  I wish to point to the following link (though it is not 100% similar, but it tells how to skip a window). Thought  others may find it useful.

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2328991547163#36924160898182

HTH

GovindanK

On Tue, 30 May 2006 14:15:07 -0400, "Bobak, Mark" <Mark.Bobak@il.proquest.com> said:

So, this was a fun little exercise…..

Everyone knows that trunc(sysdate) will return the current date, rounded to midnight, that is, currently, for me, it would return '2006-05-30 00:00:00' (assuming your nls_date_format is set appropriately).