Thanks! Sent from my iPhone
> On Sep 10, 2015, at 4:52 PM, James Heather <[email protected]> wrote: > > You want to use an UPSERT SELECT. > > UPSERT INTO mytable (primary_key_col, PULL_DATE) SELECT primary_key_col, > CURRENT_DATE() FROM mytable; > > James > >> On 10/09/15 20:40, M. Aaron Bossert wrote: >> I have a table that requires an additional column with the current date >> added. I realize that I can't do this using the CSV importer...How can I do >> that in a query? I tried standard SQL with UPSERT instead of INSERT: >> >> UPSERT INTO NG.BARS_CNC_DETAILS_HIST SET PULL_DATE=CURRENT_DATE(); >> >> >> but this gives a syntax error. >
