If You use on SQL Server select statements with output result to json structure, for instance
select * from Table FOR JSON PATH
You may feel surprise in case of DATE type and for many developers makes headache. The problem is losing time zone after converting data to json. For example: in the database we have columns date_from with timezone value 2017-04-05T15: 00: 00.000Z after using FOR JSON PATH we will get 2017-04-05T15: 00:00. The problem is serious when our systems record dates using different time zones. Problem is on Microsoft side, but You can avoid it.
If You have any columns with DATE Type then You should use format function CONVERT(datetimeoffset, ColumnName) as ColumnName like below presented:
select CONVERT(datetimeoffset, DateTimeNote) as DateTimeNote from Table FOR JSON PATH
Thanks to datetimeoffset parameter timezone in data of column will be not lost