Query to get India timezone Date & Time.

--Query to get India timezone Date & Time
SELECT TO_CHAR(SYS_EXTRACT_UTC(SYSTIMESTAMP) +
       (5.5/24), 'DD/Mon/RRRR HH24:MI:SS') IST_DATE_TIME
  FROM dual;