DISC

Contents | What's New | Quick Links

 

SQL Functions

Introduction

Software Installation

Concepts and Design

Designing Applications

Omnidex Environments

SQL Reference

Omnidex API's

Utilities

Interfaces

Performance Guide

Troubleshooting Guide

Appendix

 

 

CURRENT_TIMESTAMP

 

The CURRENT_TIMESTAMP function returns the current timestamp from the system's time-of-day clock.

The function is processed once at the beginning of execution of the SQL statement. A new value is not obtained with each reference or with each fetched row.

Syntax

Example

SQL Reference

Commands

Functions

 

Syntax

CURRENT_TIMESTAMP

top

 

Example

select company,

current_timestamp

from customers
where company='dynamic'

...

Dynamic Information Systems Corporation, 2003-01-24 14:45:04.00

 

 

top

Dynamic Information Systems Corporation - Omnidex Version 3.8 Build 6 J15.03-Copyright © 2003

DISC | Documentation Home