Kintana Script : Get database time

Purpose

The database time is used for time stamping log entries, email notifications, and by scheduled processes.

This little script us useful to verify that you are at least in the right time-zone especially if you are using a time-sync service.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the following script into SQL Runner

Omit the comment unless you're using a PL-SQL editor.
SQL Runner only supports select statements and you'll get a KNTA-10648 error.

select to_char(sysdate,'YYYY-MON-DD HH24:MI:SS') from dual

select to_char(sysdate,'YYYY-MON-DD HH24:MI:SS')
------------------------------------------------
2005-JAN-01 12:30:14

Download

KintanaScripts.zip (64 Kb)