Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Time.From
Time.FromText
Time.Hour
Time.Minute
Time.Second
Time.ToRecord
Time.ToText
Type
Uri
Values
Powered By GitBook
Time.Second

Time.Second

Returns the second component.
function (optional dateTime as nullable any) as nullable any

Description

Returns the second component of the provided time, datetime, or datetimezone value, dateTime.

Category

Time

Examples

Find the second value from a datetime value.
1
Time.Second(#datetime(2011, 12, 31, 9, 15, 36.5))
Copied!
36.5
Previous
Time.Minute
Next
Time.ToRecord
Last modified 3yr ago
Copy link
Contents
Time.Second
Description
Category
Examples