C/Front and Duration

IHateLinux
IHateLinux Member Posts: 223
edited 2005-11-21 in NAV/Navision Classic Client
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

Comments

  • rvduuren
    rvduuren Member Posts: 92
    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"
    Met vriendelijke groet, best regards,

    Rvduuren

Categories