====== MS-SQL - DateTime als DateTime mit 0 Uhr casten ======

<code sql>
SELECT CAST(CAST(GETDATE() AS DATE) AS DATETIME)
</code>

[[https://social.msdn.microsoft.com/forums/sqlserver/en-US/6e1cc462-d69e-44ea-8a29-2ef905307248/getdate-with-timestamp-000000|Quelle]]

{{tag>[MS-SQL SQL Date DateTime Cast]}}