RE: SQL, Insert data column into table

Thank you Carel, however the current date does not exist in the "from" table
so what I'm perplexed about is how to get the date and put it in there. I
just don't know SQL well enough to add that column to the statement.

--
Jim Oberholtzer
Agile Technology Architects

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Carel
via MIDRANGE-L
Sent: Tuesday, May 4, 2021 11:25 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Carel <coteijgeler@xxxxxxxxx>
Subject: Re: SQL, Insert data column into table

Use CURRENT DATE.


Op 4-5-2021 om 18:22 schreef midrangel@xxxxxxxxxxxxxxxxx:

Folks:



I have an SQL statement that's about:



Insert into mylib.mytable ( field1, field2) select field5, field6 from
table
(mylib.table2) where status = 'active';



Works well, but I need to insert the current date into the result
table, something like:



Insert into mylib.mytable ( currdate, field1, field2) select field5,
field6 from table (mylib.table2) where status = 'active';



What I don't know how to do is grab the current date and stuff it in

there.

There's no question in my mind it can be done but I am failing at
internet queries to find a method.









--

Jim Oberholtzer

Agile Technology Architects

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com