| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DATE manipulation question |
« View previous topic :: View next topic » |
| Author |
Message
|
| bolek |
 Posted: Fri Aug 27, 2004 5:38 am Post subject: DATE manipulation question |
 |
|
Apprentice
Joined: 25 Jul 2002
Posts: 35
Location: Germany
|
Hi all,
is there any 'one line' ESQL solution to get a date in past, something like
SET myDate = CURRENT_DATE - 13 Months;
Or it is really necessary to extract individual fields from CURRENT_DATE, calculate new date and convert back to DATE format ?
Thanks, |
|
| Back to top |
|
 |
| mgk |
| Posted: Fri Aug 27, 2004 5:57 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi,
This should work for you:
SET OutputRoot.XML.Top.Date = CURRENT_DATE - INTERVAL '13' MONTH;
Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| bolek |
| Posted: Fri Aug 27, 2004 6:08 am Post subject: |
|
|
Apprentice
Joined: 25 Jul 2002
Posts: 35
Location: Germany
|
| mgk wrote: |
Hi,
This should work for you:
SET OutputRoot.XML.Top.Date = CURRENT_DATE - INTERVAL '13' MONTH;
Cheers, |
Thanks !
It is really simple  |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
