SQL Millisecond date to usable excel timestamp

A

andrew

I have a SQL database with data that is sorted by timestamp whose
format is (I guess) in milliseconds.

Example: 1132628639296


I'm trying to bring this into excel, though my technical ability is
limited and I can't quite figure out how to convert this date into a
usable calendar date.


Any ideas?



Many thanks!
 
A

andrew@obo

Basically, I want the SQL time to read as an actual date/time, but I
don't know how to make this calculation in Excel (or anywhere else)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting SQL Timestamp (Milliseconds) into usable Calendar date 1
SQL date and milliseconds 6
Excel function to find difference of timestamps in milliseconds? 1
Date Timestamp 1
How to get SQL timestamp value using VB.NET 4
Date Literals That Include Milliseconds 10
How to decode integer timestamps? 8
Query milliseconds in a date field that is in a SQL Server table l 2

Top