Determine Streams Apply Lag :

Hello Experts,

i need to find following information on streams.

1. when was the message got created on source database.

2. when the message is applied on targed database.

4. is there any lag.

i am using following query to find apply Lag. it output is showing message creation time as 1988. i am not sure why it is howing very old date.  i got confused .. could you please guide me to fine why query is returning old date?

what exactly is "APPLIED_MESSAGE_CREATE_TIME" represents.

SQL> l
  1  SELECT APPLY_NAME,
  2        (APPLY_TIME-APPLIED_MESSAGE_CREATE_TIME)*86400 "Latency in Seconds",
  3         TO_CHAR(APPLIED_MESSAGE_CREATE_TIME,'HH24:MI:SS MM/DD/YYYY')