C/Front and Duration

IHateLinux

Hi,

has anyone a hint how to get a duration field in milliseconds over C/Front?
Currently we get them language dependent (e.g. ENU - 2 days 15 minutes OR DEU - 2 Tage 15 Minuten).
But we need the values to store in a SQL database as milliseconds and i like to avoid to write a converter for any existing language (e.g. Danish, Spanish,...).

Thanks a lot

Rainer

rvduuren

Hello,

Just.. a quick look in the C/AL help, might be useful for you..

BIGINTEGER
Use this data type to store very large whole numbers. This data type is a 64 bit integer. You must add an L to the constant definition to inform C/AL that the integer must be interpreted and treated as a BIGINTEGER.

DURATION
Use this data type to represent the difference between two datetimes, in milliseconds. This value can be negative. It is a 64 bit integer.
DATETIME-DATETIME=DURATION
DATETIME-DURATION=DATETIME
DATETIME+DURATION=DATETIME

Linux -- "It's computing, Rainer, but not as we know it"