I've been wondering - I have a lot of use with sysdate on my system, and when comparing it to my date columns I have to use trunc(sysdate) since the format of sysdate is DD/MM/YYYY HH24:MI:SS
.
I looked over the internet for other functions to return current date on format of DD/MM/YYYY
but had no luck, current_date , current_timestamp
and ETC also gives me the hours format..
I need this for better performance when comparing an indexed date column to the current date.
So , anybody know of a system function that returns the desired format? or a way to bypass it?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…