If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > UniVerse Date Storage Question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-27-06, 11:44
Setan Setan is offline
Registered User
 
Join Date: Jan 2006
Posts: 3
UniVerse Date Storage Question

Hello Everyone,

Quick question regarding the way the date is stored in UniVerse.

I know the date in a record is stored as a number (01JUN05 stored as 13667). What is is the reason it's done this way. I believe it has something to do with th e original folks who developed UniVerse and that the number represents the number of days since, I think January 1st 1968, but can anyone elaborate a bit more on that?

Is there a quick calculator anywhere that would do the same date conversion if you entered a number like 13667?

Mike Schallmo
Reply With Quote
  #2 (permalink)  
Old 04-01-06, 19:03
rdbmsdave rdbmsdave is offline
Registered User
 
Join Date: Apr 2006
Posts: 3
Smile UniVerse date storage question

The internal date storage used by UniVerse dates back to the days when Dick Pick first invented the Pick operating system. As the date is stored internally there can be no mistaking the intended output. When the Y2K thing was happening everyone on Pick, UniVerse, UniData, UniVision, etc could be confident that their systems would not be affected by the roll over of the century. The external date can be displayed by using an OCONV statement. If you want a way of quickly displaying what is meant by internal dates just write a routine that takes an input and oconv's it in D2 format.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On