SECOND (Report Builder)

Extracts the second from a datetime.

Syntax

SECOND(datetime)

datetime

Specifies the datetime from which the second is extracted.

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 43 52
SECOND(#6/27/2010 12:00:32 PM#)	32

See Also

Concepts

Working with Formulas (Report Builder)
Using Functions (Report Builder)
Date and Time Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance