+ Reply to Thread
Results 1 to 2 of 2

SQL Millisecond date to usable excel timestamp

  1. #1

    SQL Millisecond date to usable excel timestamp

    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!


  2. #2
    andrew@obo
    Guest

    Re: SQL Millisecond date to usable excel timestamp

    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)


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1