Sv: Date Format

[Ole Hansen]

Hi Joseph,

For this date format, PowerHouse uses a special coding scheme, as follows:

; Conversion to/from PowerHouse dates (IMAGE datatype K1).
;
;     Example:     Date     PHDATE
;
;               92 02 27    47195
;
;    92 (dec) = 1011100 (bin)
;    02 (dec) = 0010    (bin)
;    27 (dec) = 11011   (bin)
;
;    1011100001011011 (bin) = 47195 (dec)
;    |_____|___|____|
;      92   02  27                             

I have the code for a QUICK screen, which converts to and from this format. If you are interested, I will be happy to E-mail the code to you.

I don't remember the original source of this information (manual, Cognos publication or other), but we used the conversion utility for many years, for de-coding the dates seen in QUERY and en-coding for manual corrections in QUERY, until we finally got rid of the K1-format as part of the Y2K-project.

Ole Hansen

====================================================================
E-mail: oh@scanconsult.dk                Cell Phone: +45 22 17 36 50
====================================================================
ScanConsult IT-Partners ApS                Voice   : +45 87 34 55 07
Udviklingsparken Aarhus                    Fax     : +45 87 34 15 07
Soenderhoej 46                      Support : support@scanconsult.dk
DK-8260 Viby J.                     Sales   :   sales@scanconsult.dk
Denmark                             Web  : http://www.scanconsult.dk
===       ScanConsult is Authorized by Hewlett-Packard as:       ===
===     *    HP 3000 Select Independent Software Vendor    *     ===
===     **             HP9000  Power  Partner             **     ===
-----Oprindelig meddelelse-----
Fra: Joseph Rosenblatt <jrosenblatt@i2sworld.com>
Til: powerh-l <powerh-l@lists.swau.edu>
Dato: 7. februar 2000 15:25
Emne: Date Format


>I am using Version 8.09 on an HP3000. I have a date field defined in the
>dictionary as PHDATE century excluded. Image defines the field as K1. The
>valued stored is an integer.
>My question is what is the integer representation of 1/1/2000? I would also
>like to know what the formula is, i.e. what day is day 1? Thanks for your
>help.
>
>Joseph Rosenblatt
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
>Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
>This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.