CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums
Results 1 to 3 of 3

Thread: Date Format ?

  1. #1
    Join Date
    Mar 2006

    Date Format ?

    Hi !
    We have a problem. We are using an EAI Tool where we dont have access to the source files and want to code a add on to that Tool. This Tool is based on an MS SQL Database where Date/Times are stored in a Format we dont know. (we are all Oracle guys *g*)
    Can anyone help us, identify this format and tell us, how to deal with that ? Convert ? Comparison ? Add? Sub ? --> in Transact SQL :-)
    Here the example:

    00000000000000127875977359785258 --> 23/03/2006 15:28:55 (DD/MM/YYYY HH24:MI:SS)

    thx a lot !

  2. #2
    Join Date
    Mar 2006

    Re: Date Format ?

    Ok, found out myself that it is a FILEFORMAT.
    100nano sec since 1601.

    but cause I'm a Transact SQL Dumpass, I have no clue how to get it into readable format ? I'v written solutions for PL/SQL and Java ... but no clue with T SQL ?
    can anyone please give support ?

    thx in advance

  3. #3
    Join Date
    May 2005
    Sterling Heights, MI

    Re: Date Format ?

    Welcome to CodeGuru.

    How did you do it in PL/SQL?

Posting Permissions

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

Click Here to Expand Forum to Full Width