Example: Getting and Setting the Time Zone in a Java Table Operator - Advanced SQL Engine - Teradata Database

The following code excerpt shows the usage of the Java TeradataTime and TeradataTimestamp data types and the getTimeZone and setTimeZone methods for getting and setting the time zone value in a Java table operator.

String timezone = "America/New_York";
Calendar c = Calendar.getInstance();
TimeZone tz = TimeZone.getTimeZone(timezone);
c.setTimeZone(tz);

TeradataTimestamp tts = new TeradataTimestamp( c.getTimeInMillis());
tts.setTimeZone(tz);

TeradataTime tTime = new TeradataTime(c.getTimeInMillis());
tTime.setTimeZone(tz);

   if(outObjs[i] instanceof TeradataTimestamp){
      TeradataTimestamp outtts = (TeradataTimestamp)outObjs[i];
      java.util.TimeZone tz = outtts.getTimeZone();
   }
   else if(outObjs[i] instanceof TeradataTime){
      TeradataTime outtTime = (TeradataTime)outObjs[i];
      java.util.TimeZone tz = outtTime.getTimeZone();
   }
   else if(outObjs[i] instanceof Time){
      Time outtTime = (Time)outObjs[i];
      printSimpleTimeReading(outtTime);
   }
   else if(outObjs[i] instanceof Timestamp){
      Timestamp outtTime = (Timestamp)outObjs[i];
      printSimpleTimestampReading(outtTime);
   }