Import a .csv file with date column SQL SERVER

Import a .csv file with date column SQL SERVER

Hi I'm trying to import some informations from a csv file called
"test.csv" on the table students.But I get an error because on the table,
I have a "not null" column called "CreatedAt" where I store the current
date and time from the system(I don't have the date in the csv file
because I want to store the current time)
These are the table students columns:
Id-FirstName-LastName-Phone-CreatedAt
I know the function GetDate(),that returns the systems date but i don't
know how to use with the csv file importing.
Pls Help me!
Thanks in advance!