You can convert a TIMESTAMP value to a TIME value with either the CAST statement or Teradata converstion syntax.