SECOND (Report Builder 1.0)
Extracts the second from a datetime or a time field type. The result is displayed as a decimal (0-60).
Syntax
SECOND(datetime)
datetime |
Specifies the date or time from which the second is extracted. |
Remarks
- To display a datetime value as a time value, you must format the field to use one of the following custom datetime format strings on the Number tab of the Format dialog box: u, f, or s.
Example
Formula |
Result |
|---|---|
SECOND(Sell Start Date) |
Returns a second value for each instance of the Sell Start Date field, similar to the following: 32.6 43 52.5 |
SECOND(#6/27/2010 12:00:32 PM#) |
32 |
See Also