Stewart,
the SQL standard provides some help for you:
An interval data type descriptor contains:
— The name of the interval data type (INTERVAL).
— An indication of whether the interval data type is a year-month
interval or a day-time interval.
— The <interval qualifier> that describes the precision of the interval
data type.
A value described by an interval data type descriptor is always signed.
Pay attention to the last line :)
Thanks,
Roy
Stewart Smith wrote:
On Mon, Jan 12, 2009 at 07:42:56AM -0600, Tim Soderstrom wrote:
INTERVAL is the usual keyword.
Usually signed or unsigned?
signed could be useful
How so? Between the two, I think unsigned might be more commonly used
(although there's nothing saying both a signed and unsigned version
couldn't be implemented).
e.g. alarm for event starts before or after start of event by a specific
interval.
(i need that for alarm clocks "get up", "no really, wake up", "NOW!",
"okay, way up 10 minutes ago!"
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
