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.

Code Assistance

While you write SQL, the editor detects references to columns that don't exist and underlines them in real time, so you can catch typos and wrong column names before running the query.

Code Assistance
SettingDefaultDescription
Highlight unknown columnsONUnderlines columns that don't exist in the referenced tables. Hover over an underline to see a tooltip naming the table the column is missing from.
TIP

The check is based on tables whose schema has been loaded. Tables whose schema hasn't been loaded yet are excluded from the check.

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.