datetime_utc_to_local()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Converts UTC datetime to local datetime using a time-zone specification.
Syntax
datetime_utc_to_local(from,timezone)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| from | datetime |
✔️ | The UTC datetime to convert. |
| timezone | string |
✔️ | The timezone to convert to. This value must be one of the supported timezones. |
Returns
A local datetime in the timezone that corresponds the UTC datetime.
Example
print dt=now()
| extend pacific_dt = datetime_utc_to_local(dt, 'US/Pacific'), canberra_dt = datetime_utc_to_local(dt, 'Australia/Canberra')
| extend diff = pacific_dt - canberra_dt
Output
| dt | pacific_dt | canberra_dt | diff |
|---|---|---|---|
| 2022-07-11 22:18:48.4678620 | 2022-07-11 15:18:48.4678620 | 2022-07-12 08:18:48.4678620 | -17:00:00 |
Related content
- To convert a datetime from local to UTC, see datetime_local_to_utc()
- Timezones
- List of supported timezones
- format_datetime()