Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    8

    Question Unanswered: how can i convert binary(8) to datetime?

    HI!

    I tried to convert 0x01C3F0F5012D36E0, binary(8) to datetime
    But
    How can I do that?

    thanks for all

  2. #2
    Join Date
    Jan 2006
    Location
    Singapore
    Posts
    47
    what does 0x01C3F0F5012D36E0 repesent in datetime as ?
    -----------------
    KH


  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You can't convert it, it is bigger than the largest possible datetime:
    Code:
    DECLARE @dMax		DATETIME
    
    SET @dMax = '9999-12-31 23:59:59.997'
    
    SELECT Cast(@dMax AS VARBINARY(8)), 0x01C3F0F5012D36E0
    -PatP

Posting Permissions

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