GMTDateTime Conversion

Abhijeet Teli shared this idea ago

Idea Logged

Can we implement a converter that will appropriately convert the decimal field GMTDateTime in the 'Events' table of the Config DB to datetime format?

Replies (1)

Ryan Carrie ●

Hi Mayur,

Thanks for reaching out with this suggestion. In most cases, creating a Freehand SQL Calculated field at a view level can accomplish this:

CAST(GMTDateTime AS DATETIME)

however against SQL Server I was unable to get this working.

I'll keep this post updated with further information regarding this Idea.

Thanks,

Ryan