nil_dib
asked on
date and time formats?
hi,
I'm searching for date and time formats (international/computer/AN SI ....).
Anyone with a doc or web site?
I'm searching for date and time formats (international/computer/AN
Anyone with a doc or web site?
Not that I can help, but to clarify for other experts, do you mean storage formats (data formats) or do you mean "expression" formats. i.e what people use to express times and dates?
ASKER
Is there a difference between storage formats and "expression" formats?
The formats should be be used within my application ( e.g. timestamp ) but
should also displayed for the user ....
The formats should be be used within my application ( e.g. timestamp ) but
should also displayed for the user ....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Huge difference. A serial date is stored as a binary integer,where each day after a certain starting date is represented by a consevtive number. i.e. 01/01/1900 might be 0 then 01/021900 might be 1 etc. In a BCD you might store the date using 8 bytes that store the ASCII value of the date digits in year month day order, so 12/11/1998 would be stored as "19981211". In packed BCD the values would be stored using HEX digits like 0x19,0x98,0x12,0x11. There are dozens of other possibilities. These have nothing to do with how the numbers are expressed to the user.