Awesome. Thanks folks ! That’s just what I needed. Regards,
Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> From: [email protected] [mailto:[email protected]] On Behalf Of David Connors Sent: Wednesday, 8 April 2015 3:32 PM To: ozDotNet Subject: Re: Date format ??? Time since UNIX epoch + thousandths of a second precision? 1428468779331 -> GMT: Wed, 08 Apr 2015 04:52:59.331 GMT 1428468778551 -> GMT: Wed, 08 Apr 2015 04:52:58.551 GMT [cid:[email protected]] David Connors [email protected]<mailto:[email protected]> | M +61 417 189 363 Download my v-card: https://www.codify.com/cards/davidconnors Follow me on Twitter: https://www.twitter.com/davidconnors Connect with me on LinkedIn: http://au.linkedin.com/in/davidjohnconnors On Wed, Apr 8, 2015 at 3:27 PM, Greg Low (博士低格雷格) <[email protected]<mailto:[email protected]>> wrote: Hi Folks, I’m working on a 3rd party system today that stores date and time values as bigints. I might be having a slow day but I can’t seem to work out how they’ve encoded the values. Anyone seen dates/times that look like this: 1428468779331 1428468778551 Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410<tel:%2B61%20419201410> mobile│ +61 3 8676 4913<tel:%2B61%203%208676%204913> fax SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/>
