RE: How to obtain the beginning of yesterday as a time stamp

If you use the scalar function TIMESTAMP_ISO, the time part is automatically
set to midnight (i.e. 00.00.00)

Where YourTimestamp >= (Timestamp_ISO(Current_Date - 1 Day));

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike
Jones
Sent: Dienstag, 25. April 2017 22:34
To: midrange-l@xxxxxxxxxxxx
Subject: Re: How to obtain the beginning of yesterday as a time stamp

Hi Alan,

You can calculate the beginning of yesterday like this example:

values timestamp( current_date - 1 day, time( '00.00.00' ) ) ;

i.e. where MY_TIMESTAMP >= timestamp( current_date - 1 day, time( '00.00.00'
) )

Mike

date: Tue, 25 Apr 2017 20:01:05 +0000
from: Alan Shore <ashore@xxxxxxxx>
subject: How to obtain the beginning of yesterday as a time stamp

Hi everyone
I am going to play the sympathy card - so please forgive me Today, I
have just been blasted and nuked from ALL sides and my brain is just
mush Before I forget - we are on V7r1

I have a file with 3 fields of which one is a timestamp Using SQL, how
do I extract ALL the records that have a timestamp equal to or greater
than the beginning of yesterday

For example - today is April 25, 2017
I am looking to extract ALL records with a timestamp of
2017-04-24-00.00.00.000000 and greater, but I do NOT want to hardcode
that value as tomorrow, I want to extract all records with a
timestamp of 2017-04-25-00.00.00.000000 or greater and so on Hope that
makes sense

As always - all responses are always welcome



Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

--
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