Share via


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