Add month, day, time to date?

Question

SQL

There is a table with dates, 100 records, but the dates are indicated in it like this: 1922, and I need to make sure that in addition to the year there is also a month, day and time, i.e. pass the date in the table to this format: 1992-01- 01 00:00:00.
How can this be done? I read about dateadd, but I still don’t really understand how to update.

Answer 1

SELECT DATEADD( yy, 70, CAST( '1922' AS DATETIME ))