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

[James Busser]

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?