Skip to main content

Timezone Functions

Overview​

The functions covered in this section are:

CURRENT_TIMEZONE​

caution

This function isn't currently supported in PostgreSQL deployments of the Cinchy platform.

New function translations are actively being worked on by the development team; please check back at a later time.

You can review the full list of in-progress function translations here.

CURRENT_TIMEZONE returns the name of the time zone observed by the server or instance

Return Type​

varchar

Syntax​

CURRENT_TIMEZONE( )

Example​

This example returns the current timezone for the instance.

SELECT CURRENT_TIMEZONE();

current_timezone