Re: DT_DATE_TIME_DURATION usage

>>>>> "Berend" == Berend de Boer <[email protected]> writes:

>>>>> "Eric" == Eric Bezault <ericb-D6Qt/9opevxWk0Htik3J/[email protected]> writes:
    >>> Is there any other way to get the seconds between these two
    >>> dates?  Perhaps DT_DATE_TIME should have an epoch_time feature
    >>> which returns the number of seconds, that would make such
    >>> calculations far more trivial.

    Eric> Or you will get overflow because the number of seconds is
    Eric> too large to fit into an integer.

    Berend> Well, epoch does INTEGER_64 now. And this was another
    Berend> comment, that perhaps we should move to INTEGER_64 for
    Berend> certain fields, such as seconds and milliseconds.

I would second that.

The maximum possible millisecond duration is about 23 days with the current classes.
-- 
Colin Adams
Preston Lancashire