CREATEDTIME content in WORKORDER ( V7009 )
Looking at the the CREATEDTIME field in WORKORDER and understand that the date/time is stored in UNIX format, so seconds since 1st Jan 1970.
I have an entry for today of 1199902033686
When I use an online convertor that date goes wild, until I strip off some of the trailing numbers to be left with 1199902033.
So what is the 686 on the end and how do I know how much of the field to use to return a valid date/time.
SQL 2005 environment.
Kind Regards,
Andy
I have an entry for today of 1199902033686
When I use an online convertor that date goes wild, until I strip off some of the trailing numbers to be left with 1199902033.
So what is the 686 on the end and how do I know how much of the field to use to return a valid date/time.
SQL 2005 environment.
Kind Regards,
Andy