Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

CURRENT_TIMESTAMP

Name

CURRENT_TIMESTAMP -- Returns the current date and time.

Synopsis

  CURRENT_TIMESTAMP

Parameters

This function does not accept parameters.

Results

timestamp

The current date and the current time. The return data type is timestamp.

Description

Use the CURRENT_TIMESTAMP function to retrieve the current date and time in a data type of timestamp.

Examples

The following example displays the result of a call to CURRENT_TIMESTAMP:

testdb=# SELECT CURRENT_TIMESTAMP AS date_and_time;
      date_and_time
----------------------
 2001-09-04 19:48:21-08
(1 row)

 
 
  Published courtesy of O'Reilly Design by Interspire