Database Timestamp Format

Database Timestamp Format

I have created a Crystal report from the database data. But I cannot determine the format of the CREATEDTIME field in the WORKORDER table. I am trying to convert from Unix time to System using seconds from 1/1/1970. But all my date/time results are incorrect.

What is the format SupportCenter Plus uses for the CREATEDTIME entry?

Thanks




        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                        Related Products