Re: SQL time stamp starting beginning of yesterday

Correct.

The SQL 2003 Core standards specify the form with the underscore...

(from pg. 131 in the 7.2 SQL Reference)

Charles

On Tue, May 9, 2017 at 10:52 AM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

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