codetoad.com
  ASP Shopping CartForum & BBS
  - all for $20 from CodeToad Plus!
  
  Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM 
Search Site:
Search Forums:
  Converting 8 byte hex value to datetime value  Jude_Aj at 12:33 on Tuesday, March 17, 2009
 

Hi,
i am reading an .mdf file (sql server 2000 file) in raw format.
i have a value a datetime value of "f913e300 939b0000"(big endian) which represents value "Jan 16 2009 1:46PM".I had used Coledatetime class to convert this hex value to date time.Its giving me the right date but the time is incorrect.Here is what i tried to do.

int date_part = "1st 4 bytes of 8 byte date time value";//0x00009b93
int time_part = "next 4 bytes of 8 byte date time value"//0x00e313f9/1000

COleDateTime startOnDate(1900, 1, 1, 0, 0, 0);

startOnDate += COleDateTimeSpan(date_part, 0, 0, time_part);

CString buffer = startOnDate.Format();



I'm i going wrong somewhere.Is there any alternate way of doing this?
Any help would be appreciated.
Thanks









CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums








Recent Forum Threads
• C++
• Re: refresh parent after closing pop up window
• Dynamic Insertion
• Date and Time function around the world???
• Significant Factors
• Perl array access
• Re: huffman encoding and decoding in C++...
• Perl One Liner: Replace {(
• Re: html including php, accessing the functions


Recent Articles
ASP GetTempName
Decode and Encode UTF-8
ASP GetFile
ASP FolderExists
ASP FileExists
ASP OpenTextFile
ASP FilesystemObject
ASP CreateFolder
ASP CreateTextFile
Javascript Get Selected Text


© Copyright codetoad.com 2001-2009