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

 

 

Thanks

 

Mele

Outcomes