MQSeries.net :: View topic - how to get yesterday's date using esql

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to get yesterday's date using esql

how to get yesterday's date using esql

« View previous topic :: View next topic »

Author

Message

shilpa.sabade

Posted: Tue May 14, 2013 3:39 pm Post subject: how to get yesterday's date using esql

Voyager

Joined: 23 Feb 2011
Posts: 76

Hi All,

Is there a way to get yesterday's date esql..

I tried manipulations using current date ..but code is becoming lengthy while handling end of months .. accordingly need to handle end of year also..

Is there a best way to achieve this?

marko.pitkanen

Posted: Tue May 14, 2013 9:04 pm Post subject:

Chevalier

Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland

Hi,

Let broker do the job for you.
Check out what you can do with INTERVAL data type.

--
Marko

kash3338

Posted: Tue May 14, 2013 10:21 pm Post subject:

Shaman

Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India

This should work,

Code:

DECLARE curDate DATE CURRENT_DATE;
DECLARE yesterdayDate DATE;

SET yesterdayDate = curDate - INTERVAL '1' DAY;

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to get yesterday's date using esql

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP