dbTalk Databases Forums  

Strange date format

comp.databases.btrieve comp.databases.btrieve


Discuss Strange date format in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rodrigo Gonçalves
 
Posts: n/a

Default Strange date format - 11-05-2003 , 05:57 PM






Hi all,

I've got some old btrieve files(just the data, no structure file) to convert
to our systems. Using BTFiller I was able to retrieve most of the data,
except for dates. I've been trying with no sucess to understand how it is
stored...

Some samples(date and hexa values for the 4 bytes relative to it):

12/31/1999 BF 0A 31 01
10/02/2003 1A A6 31 01
01/01/1900 25 EB 21 01
01/01/1880 ED DD 1E 01


Any help would be VERY appreciated...

Tks
Rodrigo

Reply With Quote
  #2  
Old   
Curious George
 
Posts: n/a

Default Re: Strange date format - 11-06-2003 , 02:11 AM






Rodrigo:

The bytes are stored in Intel byte-swap order, so 'BF 0A 31 01' is really
'01 31 0A BF' which when entered as a hex value gives the integer value of
'19991231' which you can see is 1999-12-31.

HTH,
Martin.


"Rodrigo Gonçalves" <rodrigogoncalves (AT) yahoo (DOT) com.br> escribió en el mensaje
news:boc2on$1eh4$1 (AT) news (DOT) wplus.net...
Quote:
Hi all,

I've got some old btrieve files(just the data, no structure file) to
convert
to our systems. Using BTFiller I was able to retrieve most of the data,
except for dates. I've been trying with no sucess to understand how it is
stored...

Some samples(date and hexa values for the 4 bytes relative to it):

12/31/1999 BF 0A 31 01
10/02/2003 1A A6 31 01
01/01/1900 25 EB 21 01
01/01/1880 ED DD 1E 01


Any help would be VERY appreciated...

Tks
Rodrigo



Reply With Quote
  #3  
Old   
Gil
 
Posts: n/a

Default Re: Strange date format - 11-11-2003 , 02:19 PM



If you need to create DDF files or analzye the structure of your data
you can take a look at btsearch at www.nssdd.com. It can help you
build the DDF files.

Gil

"Curious George" <nomail (AT) myhouse (DOT) com> wrote

Quote:
Rodrigo:

The bytes are stored in Intel byte-swap order, so 'BF 0A 31 01' is really
'01 31 0A BF' which when entered as a hex value gives the integer value of
'19991231' which you can see is 1999-12-31.

HTH,
Martin.


"Rodrigo Gonçalves" <rodrigogoncalves (AT) yahoo (DOT) com.br> escribió en el mensaje
news:boc2on$1eh4$1 (AT) news (DOT) wplus.net...
Hi all,

I've got some old btrieve files(just the data, no structure file) to
convert
to our systems. Using BTFiller I was able to retrieve most of the data,
except for dates. I've been trying with no sucess to understand how it is
stored...

Some samples(date and hexa values for the 4 bytes relative to it):

12/31/1999 BF 0A 31 01
10/02/2003 1A A6 31 01
01/01/1900 25 EB 21 01
01/01/1880 ED DD 1E 01


Any help would be VERY appreciated...

Tks
Rodrigo

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.