How can I tell if dates are stored in UTC/GMT or local time?

Version 2

    Verified Product Versions

    LANDESK Service Desk 2016.xLANDESK Asset Central 2016.x

    Question

    In ITBM you can choose to store date time fields in local time or in GMT / UTC

    Answer

    To gain a list of attributes which are stored in UTC/GMT:

     

    select * from md_attribute_type where md_adjust_for_tz = 1

    Environment

    ITBM all versions