Re: ntpsec as server questions
On Thu 07 Dec 2023 at 09:37:29 (-0500), Pocket wrote:
> On 12/7/23 09:22, John Hasler wrote:
> > Greg writes:
> > > You'd think that you can determine the length of the test by
> > > subtracting the start time from the end time, right?
> > That would have worked had the times been stored as UTC (better yet, TAI
> > or Unix time since UTC can cause a similar problem). Databases should
> > never store local time.
>
> Yes that is true.
>
> I use UTC on all my systems as I have some windows machines, one win
> xp dell laptop and two win 7 one laptop and one desktop.
That must be very confusing if you mean that, for example,
the bash prompt after you'd just sent that post said:
hostname!pocket 14:38:29 ~$
Even if databases store UTC, they have to have front ends on local
time for data entry and reporting, unless you're going to have no
human involvement. And those original dates and times need to be
preserved or recreatable for auditing against any contemporary
records that are in local time. There may be several "local times"
in use in large organisations.
Cheers,
David.
Reply to: