[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] Handling of time hh:mm:ss in dob (date of birth)

From: James Busser
Subject: [Gnumed-devel] Handling of time hh:mm:ss in dob (date of birth)
Date: Thu, 21 Aug 2008 21:49:15 -0700

In the table dem.identity, dob is defined as

        timestamp with time zone

1. In such a field, is hh:mm:ss as well as the time zone optional, or will postgres not tolerate missing values?

2. If a dob cannot be entered purely as

        yyyy mm dd

does GNUMed visibly or invisibly supply a default for both hh:mm:ss as well as time zone?

3. Might the value 00:00:01 (in place of something like 07:00:00) be more unusual and therefore hinting that the time of birth is not an actual time?

4. Since the visual presentation of hh:mm:ss within the "create patient" widget will be a distraction for a majority of the users in a majority of patient creations, would the needs of the few who must capture and input a real time be met by allowing them to type in the time in the form of additional characters but without a visual prompt to do so?

5. When importing patients with an sql script, are there likewise any constraints or requirements or expectations of time within the sql scripted dates of birth?

reply via email to

[Prev in Thread] Current Thread [Next in Thread]