[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:


> 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
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?



reply via email to

[Prev in Thread] Current Thread [Next in Thread]