Re: SQL time stamp starting beginning of yesterday

Rob,

AFAIK, current date and current_date are equivalent.

Regards,

Luis

Sent from my Moto G phone. Please excuse my brevity.

On May 9, 2017 12:46 PM, "Rob Berendt" <rob@xxxxxxxxx> wrote:

Remove the underline
timestamp(current date - 1 days)
NOT
timestamp(current_date - 1 days)


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Christopher Bipes <chris.bipes@xxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 05/09/2017 12:39 PM
Subject: RE: SQL time stamp starting beginning of yesterday
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



SELECT *
FROM authsysf/oeptnslog
WHERE ttmpstmp > timestamp(current_date - 1 day)

SQL State: 42815
Vendor Code: -171
Message: [SQL0171] Argument 1 of function TIMESTAMP not valid. Cause . .

.

. . : The data type, length, or value of argument 1 of function
TIMESTAMP specified is not valid. Recovery . . . : Refer to the DB2

for

i5/OS SQL Reference topic collection in the Database category in the

i5/OS

Information Center for more information on scalar functions. Correct the
arguments specified for the function. Try the request again. Failed
statements: 1


Chris Bipes
Director of Information Services
CrossCheck, Inc.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Charles Wilt
Sent: Tuesday, May 09, 2017 9:33 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: SQL time stamp starting beginning of yesterday

It's the right direction...but on a twisty two lane road...as an index
over
ttmpstmp won't be used.

If you want to take the highway...use
ttmpstmp > timestamp(current_date - 1 day)

That will use an index over ttmpstmp...

Charles

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD