OraFAQ Forum: SQL & PL/SQL » trunc(sysdate-1) or trunc(sysdate)-1

Home » SQL & PL/SQL » SQL & PL/SQL » trunc(sysdate-1) or trunc(sysdate)-1 (10.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

trunc(sysdate-1) or trunc(sysdate)-1 [message #564318]

Wed, 22 August 2012 10:32

lott42_gmail
Messages: 146
Registered: June 2010

Senior Member

Are these two date formats equivalent?? Is one format preferred over the other??

SELECT trunc(SYSDATE - 1) date1, trunc(SYSDATE) - 1 date2 FROM dual

Result:

DATE1	   DATE2
8/21/2012  8/21/2012

Report message to a moderator

Re: trunc(sysdate-1) or trunc(sysdate)-1 [message #564320 is a reply to message #564318]

Wed, 22 August 2012 10:47

Solomon Yakobson
Messages: 3305
Registered: January 2010
Location: Connecticut, USA

Senior Member

Six or half a dozen? TRUNC(date_expression) is beginning of day of date_expression. Now sysdate - 1 is same time yeaterday. Therefore trunc(sysdate - 1) is beginning of day yesterday. trunc(sysdate) is beginning of day today. And trunc(sysdate) - 1 again is beginning of day yesterday.

SY.

Report message to a moderator

Re: trunc(sysdate-1) or trunc(sysdate)-1 [message #564322 is a reply to message #564318]

Wed, 22 August 2012 11:03

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And the result is clearer like:

SQL> SELECT trunc(SYSDATE - 1) date1, trunc(SYSDATE) - 1 date2 FROM dual;
DATE1               DATE2
------------------- -------------------
21/08/2012 00:00:00 21/08/2012 00:00:00

Regards
Michel

Report message to a moderator

Previous Topic:	PRAGMA AUTONOMOUS_TRANSACTION with DBLINK
Next Topic:	SQL that gives me Jobs due tomorrow?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 06 20:25:41 CDT 2026