SET SECONDS

From Recital Documentation Wiki
Revision as of 17:21, 10 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

SET SECONDS

Class

Date and Time Data


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(), STOD(), VTOD(), YEAR(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK


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 Database Server, Recital Mirage Server, Recital Terminal Developer