Re: Fun with SYSDATE, TRUNC() and rounding......
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 30 May 2006 13:31:47 -0700
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.
[1]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@xxxxxxxxxxxxxxx>
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).
References
1.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2328991547163#36924160898182
Other related posts:
