GMTDateTime Conversion

Mayur Randive shared this idea 5 days 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?

Comments (1)

photo
1

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