Date datatype

step 1 :
 
Open ADS
Go to File ->  Options -> Result Format 
Select MS SQL Server(Azure)
Select Data type as DATE
Select Format as NONE

step 2:

CREATE TABLE [dbo].[testDate]  ( 
        [col1]        int NOT NULL,
        [col2]        date NOT NULL,
        CONSTRAINT [pk] PRIMARY KEY CLUSTERED([col1])
)
Go
INSERT INTO [dbo].[testDate]([col1], [col2]) 
        VALUES(1, '2016-3-15')
GO

step 3:

SELECT * FROM [dbo].[testDate]
GO

Result : 
Result is not displayed in "yyyy-MM-dd" format and UTC time zone.
....................................................................................................

Datetime datatype
 
step 1 : 

Open ADS
Go to File ->  Options -> Result Format 
Select MS SQL Server(Azure)
Select Data type as DATETIME
Select Format as NONE

step 2 : 

CREATE TABLE [dbo].[testDatetime]  ( 
        [col1]        int NOT NULL,
        [col2]        datetime NOT NULL,
        CONSTRAINT [qk] PRIMARY KEY CLUSTERED([col1])
)
Go
INSERT INTO [dbo].[testDatetime]([col1], [col2]) 
        VALUES(1, '2016-3-15 15:21:37')
GO

step 3:

SELECT * FROM [dbo].[testDatetime]
GO

Result : Result is not displayed in "yyyy-MM-dd HH:mm:ss.SSS" format and UTC time zone.
..........................................................................................................

Datetime2 datatype

step 1 :

Open ADS
Go to File ->  Options -> Result Format 
Select MS SQL Server(Azure)
Select Data type as DATETIME2
Select Format as NONE

step 2 :

CREATE TABLE [dbo].[testDatetime2]  ( 
        [col1]        int NOT NULL,
        [col2]        datetime2 NOT NULL,
        CONSTRAINT [rk] PRIMARY KEY CLUSTERED([col1])
)
Go
INSERT INTO [dbo].[testDatetime2]([col1], [col2]) 
        VALUES(1, '2016-3-15 16:29:29')
GO

step 3:

SELECT * FROM [dbo].[testDatetime2]
GO

Result : Result is not displayed in "yyyy-MM-dd HH:mm:ss.SSS" format and UTC time zone.

