The precision of the result of the CURRENT_TIMESTAMP function is different depending on the generation language

Article Id: 35791
Status: Published
Updated On: 14-02-2018 07:40
Legacy Id: TEC1330261
Products:
CA Gen , CA Gen - Workstation Toolset , CA Gen - Host Encyclopedia , CA Gen - Run Time Distributed
Issue/Introduction:

Issue: 

The precision of the result of the CURRENT_TIMESTAMP function is different depending on the generation language.

  • C:     yyyy-mm-dd-hh.mm.ss.nnn000 - returns milliseconds 
  • Java: yyyy-mm-dd-hh.mm.ss.nnn000 - returns milliseconds 
  • C#:   yyyy-mm-dd-hh.mm.ss.nnnnnn - returns microseconds 

 

Environment: 

CA Gen Run Time, Internet Client: r8.0?r8.5

 

Resolution:

  • In Gen, a function is used in order to acquire the value of a CURRENT_TIMESTAMP variable from the system time. 
  • As different generation languages have been implemented in Gen over time the method used by each function has evolved, and this has resulted in improved precision for C#.
  • The value of a timestamp is kept with the format of yyyymmddhhmmssnnnnnn (20 digits). When displaying the value of a timestamp on a window, it is displayed according to the defined edit pattern for the field.

Environment:

Release: KGNDDL99000-8.5-Gen-DBP Developer License
Component: