strange date values

  • Hi All,

    I am currently trying to export date like values from oracle database to sql.

    data in oracle is char(16)... e.g. 1100131025520000

    I fail to understand what is this and how to convert it into a sql datetime...:(

  • Just guessing , but 11001310 could be the number of minutes from '01jan1970', though what 25520000 would mean is anyones guess.

    If its stored in oracle like that , you need to find the code that processes the column back to a real value in oracle.

    Clear Sky SQL
    My Blog[/url]

  • Not minutes from 1/1/1970 as that puts you in the 4000's. Could be seconds though.

    Overall this is a mystery and you need to find someone involved in creating the application so you can get a definition. Or you need to dig around the Oracle DB to find any conversion that might be done there or in the application.

    Can you use the application that connects to the database to create a row with a known date and use that to decipher the format?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • thanks Jack and Dave,

    spent the entire day searching the logic of this useless number; finally i got the logic...

    first 3 is year offset, next goes months, days, hh:mm:ss:milli --- 2,2,2,2,3...

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply