Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.


maximo result set

From: camellia.he (2014-11-11 06:59)

hi all,

Is there any chance to convert date formate in maximo result set, the request is looking for number of APPPR EM work orders base on month and show with KPI graph. for example:

select count(*), to_char(reportdate,'yyyy-mm')
from workorder
where worktype='EM'
and status ='APPR'


thanks for suggestions.