[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Adding time window to SMSD
From: |
Jan Derfinak |
Subject: |
Re: Adding time window to SMSD |
Date: |
Sat, 19 Mar 2005 11:52:59 +0100 (CET) |
On Sat, 12 Mar 2005, Martin White wrote:
Hi.
> Now for option 1) the SMS needs to be delivered immediately. But for option
> 2) the user may not want to be woken up in the middle of the night just to
> be told about a new email. I've added a time window for messages that can be
> set when the SMS is generated, if it's outside that time window the message
> will not be sent until the window is next open.
>
> I've added two columns to the outbox table, both time fields, called
> not_before and not_after. The field 'not_before' defaults to '00:00:00' and
> 'not_after' to '23:59:59' if not specified when a record is inserted.
According to postgresql manual, "time" type is times of day only without
timezone.
CURRENT_TIME delivers values with time zone.
Do you think that we can safely mix these types?
I propose to use "time" type with LOCALTIMES function. Is this OK for mysql?
jan
--