How to check ESB Activity Current Time Stamp?

To check whether the ESB instances are getting creating with current time stamp or not we have to follow the following steps.

i)The ESB_ACTIVITY Table is the standard ESB in ORA_ESB Schema.

ii)Use the below query to get time stamp value.

   select max(timestamp) from esb_activity.

iii)Get the output of this query and divide it by 1000 and use the following link to get the latest time at which the table ESB_Activity is updated. If this doesn't show current date, chances are there that the timestamp is wrongly updated in the table.

iii)http://www.onlineconversion.com/unix_time.htm

Example:

1)select max(timestamp) from esb_activity.

Output:1284378681279

2)Devide it by 1000.

  1284378681.279

3)Open http://www.onlineconversion.com/unix_time.htm

and copy the above value in UNIX TimeStamp: text box and submit it.

We will get Mon, 13 Sep 2010 11:51:21 GMT

4)Then login into ESB console and Click on instances tab and check whether instances are creating with current time stamp or not.