|
-
Jan 7th, 2013, 12:11 AM
#1
Thread Starter
Member
DateTime To Hex
Dear All
I have an application (Windows Based) developed with Sybase DBMS. Applications saves the datetime in hexadecimal format in the database. I just need to undestand how would it be generated thru application (Datetime to Hex conversion).
Below are few samples;
Sample 1:
Real Date&Time : 2013-01-06 22:38:25.000
Stored Hex Val : 0xa1c4e950
Sample 2:
Real Date&Time : 2013-01-06 22:25:07.000
Stored Hex Val : 0x83c1e950
Sample 3:
Real Date&Time : 2013-01-06 22:22:02.000
Stored Hex Val : 0xcac0e950
Can anybody help me to undestand how would be the conversion is. Data type is binary(4) for the Hexa column in database. It's urgent and early suggestions are appriciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|