AnsweredAssumed Answered

time_stamp

Question asked by mohansrinivas on Dec 23, 2014
Latest reply on Dec 24, 2014 by jw1

Hi All,

 

Am using the below SQL query to fetch the trqansfer ticket details but Iw ant the details for the particular time period(for jan 2014 to dec 2014) how to achieve this using time stamp,

can we get the ticket details using open date and close date also,please advise.

select                 ,               

call_req.ref_num,                     act_log.action_desc

From act_log  ,                                                                                  

call_req            

where act_log.call_req_id = call_req.persid

  AND act_log.description LIKE('%Transfer Group from ''SRC'' to ''ESR_EMAAP''%')

Outcomes