How to convert string (in timestamp string) to date in ms sql?

Question

SQL

Good afternoon. There is a table:

--------------------------------------------
|id (int)|name (varchar) | date (varchar)  |
|------------------------------------------|
| 1      |Nikolay        | 14496658        |
| 2      |Artem          | 14498711        |
--------------------------------------------

How can I convert the date field to DATETIME or DATE in a query.
Probyval:

SELECT 
  CAST(CAST(names.date AS TIMESTAMP) as DATE) as create_date,
  name as profile_name,
  id as id_name
FROM names

But no result.

Answer 1

What does "to no avail" mean? Such a request will return the data to you, it will be 1900.