Re: Local time in databases

2023-12-16 Thread David Wright
On Wed 13 Dec 2023 at 00:03:57 (+0700), Max Nikulin wrote: > On 08/12/2023 11:38, to...@tuxteam.de wrote: > > On Thu, Dec 07, 2023 at 10:18:44PM -0600, Nicholas Geovanis wrote: > > > > > All of these considerations are what brought Oracle to create a > > > proprietary > > > "datetime" datatype an

Re: Local time in databases (Re: ntpsec as server questions)

2023-12-12 Thread Max Nikulin
On 08/12/2023 11:38, to...@tuxteam.de wrote: On Thu, Dec 07, 2023 at 10:18:44PM -0600, Nicholas Geovanis wrote: All of these considerations are what brought Oracle to create a proprietary "datetime" datatype and use it to store all "real" dates/times. If you need a different format for display

Re: Local time in databases (Re: ntpsec as server questions)

2023-12-07 Thread tomas
On Thu, Dec 07, 2023 at 10:18:44PM -0600, Nicholas Geovanis wrote: [...] > All of these considerations are what brought Oracle to create a proprietary > "datetime" datatype and use it to store all "real" dates/times. If you need > a different format for display purposes or a human readable column

Re: Local time in databases (Re: ntpsec as server questions)

2023-12-07 Thread tomas
On Fri, Dec 08, 2023 at 09:11:12AM +0700, Max Nikulin wrote: > On 07/12/2023 23:08, tomas wrote: > > On Thu, Dec 07, 2023 at 10:29:29PM +0700, Max Nikulin wrote: > > > On 07/12/2023 21:22, John Hasler wrote: > > > > Databases should never store local time. > > > > > > There are exceptions when sto

Re: Local time in databases (Re: ntpsec as server questions)

2023-12-07 Thread Nicholas Geovanis
On Thu, Dec 7, 2023, 8:11 PM Max Nikulin wrote: > On 07/12/2023 23:08, tomas wrote: > > On Thu, Dec 07, 2023 at 10:29:29PM +0700, Max Nikulin wrote: > >> On 07/12/2023 21:22, John Hasler wrote: > >>> Databases should never store local time. > >> > >> There are exceptions when storing UTC instead

Re: Local time in databases (Re: ntpsec as server questions)

2023-12-07 Thread Max Nikulin
On 07/12/2023 23:08, tomas wrote: On Thu, Dec 07, 2023 at 10:29:29PM +0700, Max Nikulin wrote: On 07/12/2023 21:22, John Hasler wrote: Databases should never store local time. There are exceptions when storing UTC instead of local time leads to undesired consequences. Heh. There was one hug

Re: Local time in databases (Re: ntpsec as server questions)

2023-12-07 Thread tomas
On Thu, Dec 07, 2023 at 10:29:29PM +0700, Max Nikulin wrote: > On 07/12/2023 21:22, John Hasler wrote: > > Databases should never store local time. > > I am anticipating a new branch of hot discussion. > > There are exceptions when storing UTC instead of local time leads to > undesired consequenc

Local time in databases (Re: ntpsec as server questions)

2023-12-07 Thread Max Nikulin
On 07/12/2023 21:22, John Hasler wrote: Databases should never store local time. I am anticipating a new branch of hot discussion. There are exceptions when storing UTC instead of local time leads to undesired consequences. Planned (future) events may be bound namely to local time. So if t