Postgres Pro
Downloads
Home   >   mailing lists

Re: "Day" from 8am to 3am - Mailing list pgsql-sql

From Tom Lane
Subject Re: "Day" from 8am to 3am
Date
Msg-id 23892.991839463@sss.pgh.pa.us
Whole thread Raw
In response to "Day" from 8am to 3am  (Judd Maltin <judd@maltin.org>)
Responses Re: "Day" from 8am to 3am
List pgsql-sql
Tree view 
Judd Maltin <judd@maltin.org> writes:
> I have a special application that considers a playday to be from 8am to
> 3pm the next morning.  The system then does maintenance from 3am till 8am
> (if necessary).

8am is in the eye of the beholder.  Why not run the system in a timezone
selected such that a playday starts at local midnight?
        regards, tom lane

pgsql-sql by date:

Previous
From: "tjk@tksoft.com"
Date:
Subject: Re: Large Objects - lo_export
Next
From: Markus Wagner
Date:
Subject: audit trail and system catalogs