[SR-Users] time for acc records

Henning Westerholt henning.westerholt at 1und1.de
Thu Aug 11 14:16:15 CEST 2011


On Thursday 11 August 2011, Alex Hermann wrote:
> On Wednesday 10 August 2011 14:21:10 Daniel-Constantin Mierla wrote:
> > - a new column to store the seconds.milliseconds as double
> 
> Please don't use double, use a fixed point format. Double's are for
> scientific use, this is accounting so exact numbers are required.
> 
> In MySQL, one could use the DECIMAL type.

Hi Alex,

there is currently no write functionality in the DB API and also scheme 
generation XSL to support the DECIMAL type. If double is not correct for you, 
what about just storing the milliseconds as INT value e.g. 12,3s => 123 in the 
DB?

BTW, only db_mysql and db_unixodbc currently support DECIMAL value for read, 
db_mysql evaluates it to DB1_STRING, db_unixodbc to DB1_INT.

Best regards,

Henning



More information about the sr-users mailing list