LogoLogo
CtrlK
KORDocs Home
  • Tmax OpenSQL Manual
  • Tmax OpenSQL Overview
  • Tmax OpenSQL Installation
    • Prerequisites
    • OpenSQL 3.0 binary installation
      • Etcd
      • Postgresql
      • Patroni
      • OpenProxy
    • Components configuration
      • Etcd
      • Patroni
      • OpenProxy
  • Tmax OpenSQL Administration
    • Patroni
    • Etcd
      • TLS authentication
    • OpenProxy
      • Connection pool
      • Load balancing
      • Virtual IP and Redundancy
  • Tmax O2 Extensions
    • Architecture Overview
    • Installation
      • O2 Extension Installation
    • Reference guide
      • Type
      • View
      • SQL function
        • Aggregate Functions
          • LISTAGG
          • MEDIAN
          • WM_CONCAT
        • Conditional Functions
          • GREATEST
          • LEAST
          • LNNVL
          • NANVL
          • NVL
          • NVL2
        • DateTime Functions
          • ADD_MONTHS
          • DBTIMEZONE
          • LAST_DAY
          • MONTHS_BETWEEN
          • NEXT_DAY
          • ROUND
          • SESSIONTIMEZONE
          • SYS_EXTRACT_UTC
          • SYSDATE
          • SYSTIMESTAMP
          • TRUNC
        • Format Functions
          • NUMTODSINTERVAL
          • TO_CHAR
          • TO_DATE
          • TO_MULTI_BYTE
          • TO_NUMBER
          • TO_SINGLE_BYTE
          • TO_TIMESTAMP_TZ
          • UNISTR
        • Math Functions
          • BITAND
          • COSH
          • MOD
          • REMAINDER
          • SINH
          • TANH
        • Misc Functions
          • SYS_GUID
          • DUMP
        • Text Functions
          • INSTR
          • LENGTH
          • LPAD
          • LTRIM
          • NLSSORT
          • REGEXP_COUNT
          • REGEXP_INSTR
          • REGEXP_REPLACE
          • REGEXP_LIKE
          • REGEXP_SUBSTR
          • RPAD
          • RTRIM
          • SUBSTR
    • Release Note
      • 1.0
On this page
  • Syntax
  • Overview
  • Example
  1. Tmax O2 Extensions
  2. Reference guide
  3. SQL function
  4. DateTime Functions

SYSTIMESTAMP

Syntax

SYSTIMESTAMP()
RETURNS timestamptz;

Overview

The systimestamp function returns the timestamp of the current statement based on the server's time zone.

Internally, it calls GetCurrentTimestamp() to get the timestamp value based on the server's timezone.

Example

SELECT oracle.SYSTIMESTAMP();

         systimestamp          
-------------------------------
 2025-03-06 23:41:29.160617+09
(1 row)

PreviousSYSDATENextTRUNC

Last updated 1 month ago

© 2025 TmaxTibero, All Rights Reserved.