Re: SQL, Insert data column into table

[Carel <coteijgeler@xxxxxxxxx>]

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
>
>