Timestamp issues about inserting a large number of records at once

Question

Here is what I am concerned:

If I have a transaction inserts 1 million records using the getdate() function, will there be different timestamp, or will the inserted create_time always be the same?

insert into table1(id,create_time)  select id,getdate() from table2

Thanks in advance!

Answer 1

Hi @Siver

As far as I know, Getdate() returns the same value in one single statement.

If you want to ensure the same inserted create_time, it is recommended to assign getdate to a parameter and then use this parameter in the insert statement.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.