Difference between revisions of "SET SECONDS"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
(3 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Specify whether the display of datetime values includes seconds | Specify whether the display of datetime values includes seconds | ||
− | |||
==Syntax== | ==Syntax== | ||
SET SECONDS ON | OFF | (<expL>) | SET SECONDS ON | OFF | (<expL>) | ||
− | |||
==See Also== | ==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()]] | [[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== | ==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). | 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== | ==Example== | ||
Line 25: | Line 21: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|SECONDS]] | [[Category:Set_Commands|SECONDS]] | ||
− | |||
− |
Latest revision as of 10:16, 4 February 2013
Contents
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