From a29d815a7a4a583bda02c2743d92feabd34886d8 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 29 Jun 2005 01:52:56 +0000 Subject: [PATCH] Improve gettimeofday() documentation. Karl O. Pinc --- doc/src/sgml/func.sgml | 26 ++++++++++++++------------ 1 file changed, 14 insertions(+), 12 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 734686bf4a..d837219421 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ @@ -5786,15 +5786,6 @@ SELECT LOCALTIMESTAMP; CURRENT_TIMESTAMP. - - There is also the function timeofday(), which for historical - reasons returns a text string rather than a timestamp value: - -SELECT timeofday(); -Result: Sat Feb 17 19:07:32.000126 2001 EST - - - It is important to know that CURRENT_TIMESTAMP and related functions return @@ -5803,8 +5794,7 @@ SELECT timeofday(); the intent is to allow a single transaction to have a consistent notion of the current time, so that multiple modifications within the same transaction bear the same - time stamp. timeofday() - returns the wall-clock time and does advance during transactions. + time stamp. @@ -5814,6 +5804,18 @@ SELECT timeofday(); + + There is also the function timeofday() which + returns the wall-clock time and advances during transactions. For + historical reasons timeofday() returns a + text string rather than a timestamp + value: + +SELECT timeofday(); +Result: Sat Feb 17 19:07:32.000126 2001 EST + + + All the date/time data types also accept the special literal value now to specify the current date and time. Thus, -- 2.40.0