gnumed-devel
[Top][All Lists]
Advanced

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

Re: [Gnumed-devel] Default datetime precision


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Default datetime precision
Date: Sun, 25 Aug 2013 10:28:42 +0200
User-agent: Mutt/1.5.21 (2010-09-15)

On Sat, Aug 24, 2013 at 06:41:17PM +0000, Jim Busser wrote:

> At the creation of an encounter, it is sane that GNUmed offers by default, 
> and saves, either
> 
>       now()
> 
> or maybe even better
> 
>       date_trunc('minute', now())

There is no choice in that. All date/time related fields in
the database are declared "timestamp with time zone" thusly
storing full precision down to the microsecond. If they
weren't they COULD NOT store the time which is undesirable.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346



reply via email to

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