Re: How to design schema for time information

From: <phil_herring_at_yahoo.com.au>
Date: Sat, 8 Mar 2008 16:16:36 -0800 (PST)
Message-ID: <9425aa7d-dcda-4561-8d93-a57e998478df@s12g2000prg.googlegroups.com>


On Mar 7, 9:44 pm, "Shakespeare" <what..._at_xs4all.nl> wrote:

> Would it be possible to use the first 0 in to_dsinterval('0 09:00:00') to
> store the day as a number offset from e.g. monday? So for tuesday use
> to_dsinterval('1 09:00:00')? Do I understand this correctly?

You understand correctly, and yes, it would be possible. I'm not sure the result would be a better design in the sort of simple example that I used, but it might be useful if there were an arbitrary number of opening periods per day.

  • Phil
Received on Sat Mar 08 2008 - 18:16:36 CST

Original text of this message