tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

Oracle/PLSQL: SYSTIMESTAMP function

Learn how to use the Oracle/PLSQL SYSTIMESTAMP function with syntax and examples.

Description

The Oracle/PLSQL SYSTIMESTAMP function returns the current system date and time (including fractional seconds and time zone) on your local database.

Syntax

The syntax for the Oracle/PLSQL SYSTIMESTAMP function is:

SYSTIMESTAMP

Parameters or Arguments

There are no parameters or arguments for the SYSTIMESTAMP function.

Applies To

The SYSTIMESTAMP function can be used in the following versions of Oracle/PLSQL:

  • Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i

Example

Let's look at some Oracle SYSTIMESTAMP function examples and explore how to use the SYSTIMESTAMP function in Oracle/PLSQL.

For example:

SELECT SYSTIMESTAMP
FROM dual;

The systimestamp function might return a value like this:

03-11-21 20:4

You can also choose to use the TO_CHAR function with the SYSTIMESTAMP function. For example:

SELECT TO_CHAR(SYSTIMESTAMP, 'SSSS.FF')
FROM dual;

The function above may return a value such as:

4141.550774