DATE AND TIME

 Oracle DB:

Function -------------------	Description ------------------------------------------------	Time Zone Used -------------------------------
SYSDATE	Server date/time (from OS)	❌ Not affected by session TZ
SYSTIMESTAMP	Server timestamp with time zone	❌ Not affected by session TZ
CURRENT_DATE	Session date/time (no TZ shown)	✅ Affected by session TZ
CURRENT_TIMESTAMP	Session timestamp with time zone	✅ Affected by session TZ
LOCALTIMESTAMP	Session timestamp (no TZ info, but adjusted)	✅ Affected by session TZ

----------------------------------------------------------------------------------------------------------------

Linux: 

export TZ=<Time_Zone_Name>

[root@localhost ~]# export TZ=Asia/Kolkata

[root@localhost ~]# date

Thu Aug  7 05:32:26 PM IST 2025

Region -------------	Time Zone Name -----------------------	UTC Offset -------------------------------	Description / Area -------------------------
Africa	Africa/Johannesburg	UTC+02:00	South Africa
	Africa/Cairo	UTC+02:00	Egypt
	Africa/Nairobi	UTC+03:00	Kenya
	Africa/Lagos	UTC+01:00	Nigeria
America	America/Toronto	UTC-05:00 / -04:00 DST	Canada – Eastern Time
	America/Vancouver	UTC-08:00 / -07:00 DST	Canada – Pacific Time
	America/Edmonton	UTC-07:00 / -06:00 DST	Canada – Mountain Time
	America/Winnipeg	UTC-06:00 / -05:00 DST	Canada – Central Time
	America/St_Johns	UTC-03:30 / -02:30 DST	Canada – Newfoundland
	America/New_York	UTC-05:00 / -04:00 DST	USA – Eastern Time
	America/Chicago	UTC-06:00 / -05:00 DST	USA – Central Time
	America/Denver	UTC-07:00 / -06:00 DST	USA – Mountain Time
	America/Los_Angeles	UTC-08:00 / -07:00 DST	USA – Pacific Time
	America/Bogota	UTC-05:00	Colombia
Asia	Asia/Kolkata	UTC+05:30	India
	Asia/Dubai	UTC+04:00	UAE
	Asia/Tokyo	UTC+09:00	Japan
	Asia/Singapore	UTC+08:00	Singapore
	Asia/Shanghai	UTC+08:00	China
	Asia/Karachi	UTC+05:00	Pakistan
	Asia/Tehran	UTC+03:30	Iran
Europe	Europe/London	UTC+00:00 / +01:00 DST	UK
	Europe/Berlin	UTC+01:00 / +02:00 DST	Germany
	Europe/Paris	UTC+01:00 / +02:00 DST	France
	Europe/Moscow	UTC+03:00	Russia
	Europe/Istanbul	UTC+03:00	Turkey
Australia	Australia/Sydney	UTC+10:00 / +11:00 DST	New South Wales
	Australia/Perth	UTC+08:00	Western Australia
	Australia/Melbourne	UTC+10:00 / +11:00 DST	Victoria
UTC/GMT	Etc/UTC	UTC+00:00	Coordinated Universal Time
	Etc/GMT+5	UTC-05:00	Fixed offset (reverse sign!)
Canada TZ	Canada/Eastern (alias)	UTC-05:00 / -04:00 DST	Alias for America/Toronto
	Canada/Pacific (alias)	UTC-08:00 / -07:00 DST	Alias for America/Vancouver

---------------------------------------------------------------------------------------------------------------