# to\_char

Published articles for to\_char.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## How to render timestamp with a timezone that is different from current?

DevFeed: [How to render timestamp with a timezone that is different from current?](<https://devfeed.tech/articles/how-to-render-timestamp-with-a-timezone-that-is-different-from-current-33675.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/01/27/how-to-render-timestamp-with-a-timezone-that-is-different-from-current/>)

Author: depesz

Published: 2026-01-27T09:25:04Z

Content type: tutorial

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [DateTime](<https://devfeed.tech/topics/datetime.md>)

Tags: [formatting](<https://devfeed.tech/tags/formatting.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [irc](<https://devfeed.tech/tags/irc.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [timestamptz](<https://devfeed.tech/tags/timestamptz.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [to-char](<https://devfeed.tech/tags/to-char.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [utc](<https://devfeed.tech/tags/utc.md>)

### AI overview

A PostgreSQL tutorial explaining why timestamptz values are displayed in the client's local timezone and how to render a timestamp with an offset for another timezone. It presents a custom function that returns text, preserves the client timezone, and optionally applies to_char formatting.

### Source excerpt

This question appeared on IRC, and while I wasn't there while it happened, it caught my eye: " Can I not render this with timezone offset: select '2026-01-09 04:35:46.9824-08'::timestamp with time zone at time zone 'UTC'; " Returns '2026-01-09 12:35:46.9824' which is without the offset. Let's see what can be done about it. First, let's ... Continue reading "How to render timestamp with a timezone that is different from current?"