Sysdate for DB2

Anyone know the syntax for building an object for sysdate in db2?

I need to run a report parsing out the month and year for sysdate and running the report for the month prior on Broadcaset agent each month

Thanks,

Julie


Listserv Archives (BOB member since 2002-06-25)

did you try “current date”

Vasan

julie.neumann@DOT.STATE.WI.US on 04/17/2000 12:06:23 PM

Anyone know the syntax for building an object for sysdate in db2?

I need to run a report parsing out the month and year for sysdate and running the report for the month prior on Broadcaset agent each month

Thanks,

Julie

******************************************************************************* Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Ernst & Young LLP



Listserv Archives (BOB member since 2002-06-25)