Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
DateTimeZone.FixedLocalNow
DateTimeZone.FixedUtcNow
DateTimeZone.From
DateTimeZone.FromFileTime
DateTimeZone.FromText
DateTimeZone.LocalNow
DateTimeZone.RemoveZone
DateTimeZone.SwitchZone
DateTimeZone.ToLocal
DateTimeZone.ToRecord
DateTimeZone.ToText
DateTimeZone.ToUtc
DateTimeZone.UtcNow
DateTimeZone.ZoneHours
DateTimeZone.ZoneMinutes
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
DateTimeZone.ToText

DateTimeZone.ToText

Returns a textual representation of the datetimezone value.
function (optional dateTimeZone as nullable any, optional format as nullable any, optional culture as nullable any) as nullable any

Description

Returns a textual representation of dateTimeZone, the datetimezone value, dateTimeZone. This function takes in an optional format parameter format. For a complete list of supported formats, please refer to the Library specification document.

Category

DateTimeZone

Examples

Get a textual representation of #datetimezone(2011, 12, 31, 11, 56, 2, 8, 0).
1
DateTimeZone.ToText(#datetimezone(2010, 12, 31, 11, 56, 2, 8, 0))
Copied!
"12/31/2010 11:56:02 AM +08:00"
Get a textual representation of #datetimezone(2010, 12, 31, 11, 56, 2, 10, 12) with format option.
1
DateTimeZone.ToText(#datetimezone(2010, 12, 31, 11, 56, 2, 10, 12), "yyyy/MM/ddThh:mm:sszzz")
Copied!
"2010/12/31T11:56:02+10:12"
Previous
DateTimeZone.ToRecord
Next
DateTimeZone.ToUtc
Last modified 3yr ago
Copy link
Contents
DateTimeZone.ToText
Description
Category
Examples