Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jano Petras Get DATE part of the DATETIME RE: Get DATE part of the DATETIME
jreece
Ten Centuries
Points: 1138
More actions
June 14, 2011 at 8:34 am
#1338432
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.