title: UTC timezone for "date" and "time" datatypes in Azure SQL
body: <p>I'm planning to use <a href="https://docs.microsoft.com/en-us/sql/t-sql/data-types/date-transact-sql" rel="nofollow noreferrer">date</a> and <a href="https://docs.microsoft.com/en-us/sql/t-sql/data-types/time-transact-sql" rel="nofollow noreferrer">time</a> datatypes in my SQL Server 2016 Express database, which I will be deploying to an Azure SQL database in the production environment. </p>
  
  <p>I know for the "datetime2" datatype, Azure SQL stores it in UTC timezone. Is this also the case for "date" and "time"? The Microsoft references (linked above), date and time's are not "Time zone offset aware and preservation". </p>
  
  <p>Does this mean they are not stored in UTC time like datetime2? Do I still have to worry about converting to and from UTC time?</p>