how to get timestamp/system date from SQL

[Guest.Visitor]

There are "special registers" in SQL that you can use. CURRENT DATE = system date CURRENT TIME = system time CURRENT TIMESTAMP = system timestamp (date & time)

[ACT]

how to get timestamp/system date from SQL

Thank you Kadams1. But from what table ? Is there like a dummy table similar to Oracle?

[Guest.Visitor]

how to get timestamp/system date from SQL

Special registers are like system variables. They can be used with no regard to which files are being used by the SQL. Try the following with any file - select current date, current time, current timestamp from [file-name];

[robberendt]

how to get timestamp/system date from SQL

Use the following sample instead:

---

Code

[ACT]

how to get timestamp/system date from SQL

How to get timestamp/system date from sql.TIA.

[ukpi1b]

how to get timestamp/system date from SQL

FYI. One record dummy file SYSDUMMY1 is currently available in SYSIBM library.