Insert into mylib.mytable ( field1, field2) select current_date, field5,
field6 from
table
(mylib.table2) where status = 'active';
Paul Therrien
paultherrien@xxxxxxxxxxxxxxxxxx
225-229-2491
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
midrangel@xxxxxxxxxxxxxxxxx
Sent: Tuesday, May 4, 2021 12:37 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: 'Carel' <coteijgeler@xxxxxxxxx>
Subject: 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
--
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
midrange.com
