This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hello friends. Needless to say, I have run into my first Maximo with DB2. Trying to put in the usual queries and now I need to use the system date, so I can find work created in the last 7 days which would typically be
reportdate>sysdate-7 (oracle) or
reportdate>getdate()-7 (sql server).
Anyone know the equivalent for IBM DB2?
For DB2 use: CURRENT DATE - 7 DAYS
You might find this DB2 SQL cookbook useful -
http://mysite.verizon.net/Graeme_Birchall/id1.html - it is one of the best
DB2 documents that I have found full of practical examples as well.
Pete Meechan
Principal Consultant
Email: orb.maximo@googlemail.com
Twitter: @OrbData
Switchboard: +44 (0) 1628 550450
Address: The Chapel, Grenville Court, Britwell Road, Burnham, SL1 8DF,
United Kingdom
<http://www.orb-data.com/> www.orb-data.com
<http://www.orb-data.com/products/ssp> Orb Data Self-Service Portal
AAA Accredited IBM
Business Partner
Self-service for
Tivoli Monitoring
Orb Data Limited, registered in England No. 03429749
Registered Office, 29 Devizes Road, Swindon, Wiltshire, SN1 4BG, United
Kingdom
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
cnwinston
Sent: Wednesday, March 20, 2013 7:37 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] what is the DB2 value for getdate() (sql server) or
sysdate (oracle)?
Hello friends. Needless to say, I have run into my first Maximo with DB2.
Trying to put in the usual queries and now I need to use the system date, so
I can find work created in the last 7 days which would typically be
reportdate>sysdate-7 (oracle) or
reportdate>getdate()-7 (sql server).
Anyone know the equivalent for IBM DB2?
Found the answer here:
http://www.ibm.com/developerworks/forums/thread.jspa?threadID=269604
--- In MAXIMO@yahoogroups.com, "cnwinston" <cnwinston@...> wrote:
>
> Hello friends. Needless to say, I have run into my first Maximo with DB2. Trying to put in the usual queries and now I need to use the system date, so I can find work created in the last 7 days which would typically be
>
> reportdate>sysdate-7 (oracle) or
> reportdate>getdate()-7 (sql server).
>
> Anyone know the equivalent for IBM DB2?
>