OpsCenter custom report using query

[Thiago_Pereira]

how do I convert the date fields in OpsCenter for the DATETIME format in a custom report using Query?

EXAMPLE:

SELECT startTime FROM domain_Job

This column is a timestamp format, how I convert? Its possible?

[SParashar · Accepted solution]

Try this.

SELECT "DBA"."UTCBigintToUTCTime"(startTime) FROM domain_Job

[Thiago_Pereira]

Thank's SParashar

This solution will resolve me life but, you know how to change the format of date or is only possible in this way?

Like YYYYMMMDD HH:MM:SS

[SParashar]

Which version of OpsCenter you are using.

I think the format should be based to the locale selected for the user. So for English locale the format should be MMM dd, YYYY HH:MM:SS. What is the Default locale selected under Settings/User Preferences.

[Thiago_Pereira]

It worked as you described.

Thank's for help.

[Thiago_Pereira]

Yes, like me default locale.

[SParashar]

Is the data shown in the expected date format?