Separate Date and time Feld from Query on Control-M
Posted: 03 Dec 2012 4:25
Hi there, i have an issue regarding Reporting os Sucess Of Jobs ended OK.
I run this query against a View of ours called CUST_ALLJOBS.
Select JOB_NAME,MEMNAME,ODATE, elapsed, start_time, end_time
FROM CUST_ALLJOBS where STATUS like 'Ended OK' and GROUP_NAME like 'DW-SCADA' and ODATE like '1211%'
and JOB_NAME like 'DIARIO_NEW'
The result is like this:
DIARIO_NEW Diario.bat 121105 20121106035931 20121106060638
But our costumer needs to have separated the date and time in 2 columns. Anyone have done this? Or exist some other Table where i can have the same results but with Date and Time separated.
Regards,
osafr71
I run this query against a View of ours called CUST_ALLJOBS.
Select JOB_NAME,MEMNAME,ODATE, elapsed, start_time, end_time
FROM CUST_ALLJOBS where STATUS like 'Ended OK' and GROUP_NAME like 'DW-SCADA' and ODATE like '1211%'
and JOB_NAME like 'DIARIO_NEW'
The result is like this:
DIARIO_NEW Diario.bat 121105 20121106035931 20121106060638
But our costumer needs to have separated the date and time in 2 columns. Anyone have done this? Or exist some other Table where i can have the same results but with Date and Time separated.
Regards,
osafr71