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
Copy link
Contents
Time.Second
Description
Category
Examples