Subject Re: isc_encode_time and millisconds
Author grenzil
--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> wrote:

Hi, I tried as you suggest but seems not work.

Just one more info .. TmpDate, which is tm_structure filled with all the data, so could be thais the problem?
I mean I fill TmpDate, and that procedure copy that data to sqldata, overwriting msec data previouly inserted?

Thank you
Lucio

>
> > PISC_TIME(sqldata) := PISC_TIME(sqldata) + (msec % 10000)
> >
> > isc_encode_sql_time(@TmpDate, PISC_TIME(sqldata))
> >
> > msec info is not stored. So can someone provide an example how can I do to store msec infos?
>
> Everything is simple:
>
> PISC_TIME(sqldata) := (((hours*60)+minutes)*60+seconds)*10000+msec*10;
>
> ISC_TIME is number of 1/10000th seconds after midnight.
>
> SY, SD.
>