• I was using Method 4, saw this post and was an immediate convert to Method 1 till I saw Method 3, the simplest yet, and as it turns out, the fastest!

    But nothing beats the simplicity of TRUNC(sysdate) - a PL/SQL function I really miss.