INSERT INTO SELECT with CURRENT_TIMESTAMP value

I have a query that takes all data from database A and inserts it into database B. It is working correctly, however I created a new column in database B called “actual_date” and I would like that, when inserting the data in database B, also insert the current date when these values were entered in database B.

Something like:

INSERT INTO databaseB(col1, col2, actual_date) SELECT databaseA.col1, databaseA.col2, CURRENT_TIMESTAMP FROM databaseA

​x
 
INSERT INTO databaseB(col1, col2, actual_date) SELECT databaseA.col1, databaseA.col2, CURRENT_TIMESTAMP FROM databaseA​

Obviously the above query is wrong, but it would be something like this, because in database A, there is no column with the current date.

Is this possible?

Answer

Use Date():

INSERT INTO 
    databaseB (col1, col2, actual_date) 
SELECT 
    databaseA.col1, databaseA.col2, Date() 
FROM 
    databaseA

 
INSERT INTO     databaseB (col1, col2, actual_date) SELECT     databaseA.col1, databaseA.col2, Date() FROM     databaseA​

Advertisement

Answer