How to get date in date format?

Question

SQL Server

SELECT fullname, startdate FROM course
startdate - stored in bigint format. How to output it in date format?

Answer 1

it turned out like this
DATE_FORMAT(FROM_UNIXTIME(startdate),'%Y-%m-%d')

Answer 2

https://docs.microsoft.com/ru-RU/sql/t-sql/functio...