Nearest midnight: won't TRUNC(sysdate + 0.5)+1/(24*60) do that?
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Forum Rules
Reply With Quote