10-03-2011 07:01 AM
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?
Solved! Go to Solution.
10-03-2011 07:26 AM
Try this.
SELECT "DBA"."UTCBigintToUTCTime"(startTime) FROM domain_Job
10-03-2011 07:26 AM
Try this.
SELECT "DBA"."UTCBigintToUTCTime"(startTime) FROM domain_Job
10-03-2011 11:19 AM
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
10-04-2011 09:42 AM
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.
10-04-2011 10:17 AM
It worked as you described.
Thank's for help.
10-05-2011 05:54 AM
Yes, like me default locale.
10-05-2011 10:05 AM
Is the data shown in the expected date format?