Re: Adding time window to SMSD

[Jan Derfinak]

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

--