# SQL Server date times explained

```sql

declare @this_datetime datetime = getutcdate()
declare @this_datetime2 datetime2 = getutcdate()
declare @this_smaldatetime smalldatetime = getutcdate()

select @this_datetime, @this_datetime2, @this_smaldatetime

select datalength(@this_datetime), datalength(@this_datetime2), datalength(@this_smaldatetime)
```


![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1647439773942/AqsBG8CYS.png)