Re: DATE Function in embedded SQL

From the Manuel:

"The CURDATE function returns a date based on a reading of the time-of-day
clock when the SQL statement is executed at the current server. The value
returned by the CURDATE function is the same as the value returned by the
CURRENT DATE special register.
The CURRENT_DATE special register should be used for maximal portability."

Brian.

On 24 May 2017 at 18:47, Rob Berendt <rob@xxxxxxxxx> wrote:

I might download those PDF's but I would just "put them on a shelf in
case". IBM updates Knowledge Center quite frequently and it's irksome
when someone uses old documentation.
I walked around the office after hours and discarded all printed RPG
manuals because I was tired of people limiting themselves to stuff in a V3
manual.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Dan <dan27649@xxxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 05/24/2017 01:41 PM
Subject: Re: DATE Function in embedded SQL
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



If you don't already have it, I'd highly recommend that you download the
SQL Reference and SQL Programming PDFs for your OS version.

Grab them before IBM decides no one really needs the PDFs anymore.
Because, you know, you can easily find everything in KnowledgeCenter.
</snark>

- Dan

On Wed, May 24, 2017 at 12:00 PM, Marvin Radding <
marvin.radding@xxxxxxxxxxxxxxxxxxxxx> wrote:

Is there a function in SQL that will give you the current date?

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-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


--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-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