AnsweredAssumed Answered

DateTime in Query Layer?

Question asked by mkoneya on Jan 12, 2019
Latest reply on Jan 13, 2019 by bixb0012

How can I get a Query Layer to show DateTime for the data type instead of Date?


I am wanting to use a query layer to append to an SDE Feature class and if the format is Date, then the append process puts NULL instead of the Date.


I have tried multiple ways in the SQL query in both ArcMap and ArcGIS but each time it shows as a Date Data Type in the Query Layer


This SQL query did not work,


,CAST(DATEADD(second, DATEDIFF(second, GETDATE(), GETUTCDATE()), CreatedDate) AS DateTime2) AS CreatedDate