Timezone can be set in Teradata in System level, User level or in Session level. to set time zone in system level you need to modify dbs control parameter.
Timezone can be set at user level while creating user as
Create user user name TIME ZONE=LOCAL (or TIME ZONE='5:30',TIME ZONE=NULL).
At session level it can be set by set command. to set timezone to local (i.e. Current System's Timezone) you can issue in current session.
SET TIME ZONE LOCAL
to set time zone to a specific timezone issue below command.
SET TIME ZONE INTERVAL '05:00' HOUR TO MINUTE
Timezone can be set at user level while creating user as
Create user user name TIME ZONE=LOCAL (or TIME ZONE='5:30',TIME ZONE=NULL).
At session level it can be set by set command. to set timezone to local (i.e. Current System's Timezone) you can issue in current session.
SET TIME ZONE LOCAL
to set time zone to a specific timezone issue below command.
SET TIME ZONE INTERVAL '05:00' HOUR TO MINUTE
No comments:
Post a Comment