>I have a minutes numeric field mytable.minutes
>
>But when I have a great large of minutes as 720 or more I would like to store them
>in a datetime field
>
>Replace mytable.datetime with mytable.minutes * 60 + mytable.minutes
>
>But I have to reset mytable.datetime field to zero before sum
>
>How can I do it ?
>
>Moises
BTW, if you only need to store time intervals ( in minutes), then I would just use a numeric field (big one) as you already are using.
If it's not broken, fix it until it is.
My Blog