CREATE DATABASE DataExamples

create table dateexample
(
	Column_with_standart datetime,
	Column_with_getdate datetime,
	Column_with_style datetime
)

select Column_with_standart AS [Стандартен],
	   Column_with_getdate AS [Функция за локално време],
	   Column_with_style AS [Конвъртната към стил]
FROM   dateexample


insert into dateexample values ('2019-09-23 23:07:40.190', getdate(), CONVERT(datetime, '20170101', 105))

--select getdate()