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 [?]
David Connors da...@connors.com | 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 (博士低格雷格) <g...@greglow.com> 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 mobile│ +61 3 8676 4913 > fax > > SQL Down Under | Web: www.sqldownunder.com > > >