Author Topic: arsdoc query on System log retruns timestamp without fraction of seconds  (Read 1954 times)

SV

  • Guest
CMOD 9.0 on AIX - System log updated to new date format. Now the issue is "arsdoc query" on system log is not returning the timestamp in new date/time format.

When using windows client system log query returns the new date/time format as shown below: 

2016-07-04 06:39:49.422006   SECURE   100553   Info   Yes       34   User Add: Userid(USER1) Id(126)

Whereas "arsdoc query" returns timestamp as shown below. Is there anything missed, how do I get the query result to return new date/time style?

07/04/16 06:39:49,SECURE,4,34,User Add: Userid(NWUSER1) Id(126),T,100553,

Jaydeep Mehta

  • Guest

Hi SV,

In windows client you able to see date format 2016-07-04 06:39:49.422006  beacuse in CMOD 9.0 internally  it mapped with time_stamp_dt   new date format  field  but If you see System Log AG  you can see  time_stamp field mapped with Date/Time(TZ)(old style) there is no such field time_stamp_dt .

So Whereas "arsdoc query" will returns result in time_stamp (07/04/16 06:39:49 )format only .