Okay, so then my time format is what's important.. We don't care about
seconds and I want military times stored, so I could set my time format to
HH:MM. I can use cval('timeformat') to set the time format back to its default.
So if I'm sure that all my DateTime values wil have that time format and I
subtract them, then I should get a difference in minutes right? If that's
the case then that's exact what I need. I just have to make sure I set my
time format.
Karen
In a message dated 10/17/2012 8:35:17 AM Central Daylight Time,
[email protected] writes:
> Yes, it's milliseconds if your time format includes ss.sss, it's
> centiseconds if time format is ss.ss, deciseconds if time format contains
> ss.s, and
> seconds if time format has ss.
>
> If you subtract DATES from each other, the integer is always days.
>
> You should always check or enforce the appropriate time format before
> doing subtraction with time or date-time values. ADDSEC gives the same
> result
> no matter what the format, so I would recommend you use that instead of
> just adding integers to datetime or time, the way we had to in the very old
> days.
>
> Adding integers to dates should always be a date, integer number of days
> away, but ADDDAY is clear in its definition, so I would recommend that,
> too.
>
>
>
>
>
> Bill
>
>
>
>
