SQL Editor Project Settings

Learn about project-level settings for the SQL Editor, including date/time display format and indentation.

Timezone

Set the timezone used to display date/time values in the result grid.

The default is the browser's local timezone (e.g., Asia/Seoul).

The default is the browser's local timezone (e.g., <code>Asia/Seoul</code>).
Date TypeTimezone Application
Naive types
DATE, TIME, DATETIME, TIMESTAMP
Displayed exactly as stored in the database, regardless of the Timezone setting. No timezone conversion is applied.
Aware types
TIMESTAMPTZ, TIMETZ, DATETIMEOFFSET
Converted to the configured timezone for display. The UTC offset (e.g., +09:00) is shown in the column header.
TIP

The Timezone setting only affects Aware type columns. Naive types are not affected by timezone changes. For example, to view a PostgreSQL TIMESTAMPTZ column in Korean time, select Asia/Seoul.

Timestamp Format / Date Format / Time Format

Set the format for displaying date/time values in the result grid.

SettingDefaultApplies To
Timestamp FormatYYYY-MM-DD HH:mm:ss.SSSDATETIME, TIMESTAMP, TIMESTAMPTZ date+time columns
Date FormatYYYY-MM-DDDATE type columns
Time FormatHH:mm:ssTIME type columns

Available format tokens:

TokenMeaningExample
YYYY4-digit year2026
MM2-digit month05
DD2-digit day13
HH2-digit hour (24-hour)14
mm2-digit minute30
ss2-digit second45
SSSMilliseconds123

Indentation

Configure the indentation style and size for the SQL Editor.

docs.sqlEditorSettings.indent.defaultDesc
SettingOptionsDefault
Indent styleSpaces / TabsSpaces
Tab Size2 / 4 / 82

This setting applies both to characters inserted when pressing Tab and to SQL formatting results.

Preview

When you change Timezone and date/time format in the settings, a real-time preview based on the current time is displayed.

docs.sqlEditorSettings.preview.defaultDesc
Preview ItemDisplay Example
TIMESTAMP2026-05-13 14:30:45.123
DATE2026-05-13
TIME14:30:45

The preview lets you immediately see how dates will be displayed in the result grid after changing settings.