UTC time in IDMS

Products

• IDMS

Issue/Introduction

This article describes how to return the current UTC time in IDMS.

Environment

Release : Any supported release.
Component : IDMS/SQL Option

Resolution

The following SQL select can be used to return the current UTC:

SELECT CURRENT TIMESTAMP - HOUR(CURRENT TIMEZONE) HOURS
- MINUTE(CURRENT TIMEZONE) MINUTES AS UTC
FROM SYSCA.SINGLETON_NULL;
*+
*+ UTC
*+ ---
*+ 2022-05-04-10.02.15.230536
*+
*+ 1 row processed

Additional Information

Date/time Arithmetic
SYSCA Pseudo Table SINGLETON_NULL