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

From Judd Maltin
Subject Re: "Day" from 8am to 3am
Date
Msg-id Pine.LNX.4.21.0106061016310.22339-100000@kislev.maltin.org
Whole thread Raw
In response to Re: "Day" from 8am to 3am  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Wed, 6 Jun 2001, Tom Lane wrote:

> 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


Isn't changing the system for the application breaking a cardinal rule of
systems design?

I need the real time of day anyway.. I just want to make SELECTs easier.

-judd



pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: seleting all dates between two dates
Next
From: Peter Eisentraut
Date:
Subject: Re: help with a function