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

[Jerzy Luszawski]

Saturday 23 August 2008 13:20:39 Karsten Hilbert napisał(a):
> On Sat, Aug 23, 2008 at 10:44:57AM +0200, Jerzy Luszawski wrote:
> 
> > Looking from practical point of view: except perhaps
> > neonatologists noone cares for time of birth, so why bother
> > everyone with it? 
> Because we try to model reality. But we can chose how as
> described in an earlier mail.
> 
(...)
> > Consider this: dob = '2008-08-03 20:00' now =
> > '2008-08-22 15:00' patient age = ? I thing most doctors
> > would rather have this as 19 days (days difference) than 18
> > days with couple of hours, as exact comparison returns.
> 
> That's a frontend/display issue. Nothing to do with the
> backend. The database should store "the truth" and not
> something we at a certain point in time considered "enough".
> 
I certainly do not object to modeling reality and storing the "truth", but IMHO 
it will be easier when date and time are stored in separate field. This way we 
do not loose any information, but handling is easier.

Jerzy