Difference between revisions of "SET SECONDS"

From Recital Documentation Wiki
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET SECONDS=
 
 
 
==Class==
 
Date and Time Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Specify whether the display of datetime values includes seconds
 
Specify whether the display of datetime values includes seconds
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
CDOW(), CMONTH(), CTOD(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), EPOCH(), GOMONTH(), MDY(), MONTH(), MTOD(), QUARTER(), STOD(), VTOD(), YEAR(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK
+
[[CDOW()]], [[CMONTH()]], [[CTOD()]], [[DATE()]], [[DATETIME()]], [[DAY()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[EPOCH()]], [[GOMONTH()]], [[MDY()]], [[MONTH()]], [[MTOD()]], [[QUARTER()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[SET HOURS]], [[SET MARK]], [[STOD()]], [[VTOD()]], [[YEAR()]]
  
  
Line 23: Line 16:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
set seconds off
 
set seconds off
 
? datetime()
 
? datetime()
Line 29: Line 22:
 
set seconds on
 
set seconds on
 
? datetime()
 
? datetime()
01/23/2004 01:18:22 PM</pre>
+
01/23/2004 01:18:22 PM
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
[[Category:Set_Commands]]
+
[[Category:Set_Commands|SECONDS]]
 +
[[Category:Date and Time Data]]
 +
[[Category:Date and Time Data Set Commands]]

Latest revision as of 15:27, 25 November 2009

Purpose

Specify whether the display of datetime values includes seconds


Syntax

SET SECONDS ON | OFF | (<expL>)


See Also

CDOW(), CMONTH(), CTOD(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), EPOCH(), GOMONTH(), MDY(), MONTH(), MTOD(), QUARTER(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, STOD(), VTOD(), YEAR()


Description

If SET SECONDS is ON, then the display of datetime values includes seconds. If SECONDS is OFF then the time part of datetime values only includes hours, minutes and AM | PM. By default, SECONDS is ON. The SET HOURS set command determines whether hours are shown in 24 hour format (OFF) or in 12 hour format with AM | PM postfix (ON).


Example

set seconds off
? datetime()
01/23/2004 01:18 PM
set seconds on
? datetime()
01/23/2004 01:18:22 PM


Products

Recital Server, Recital