Working with Teradata Time and Timstamp in non conventional format.

Working with TIME and TIME STAMP in non conventional format is a big headache.

Below mentioned simple technique will ease this.

1) For TIME

'08-09-17PM' (time, format 'HH-MI-SST')

Here we explicitly specify the format 

2) For Timestamp

'12/25/1994 11:46:29PM' (timestamp, format 'MM/DD/YYYYBHH:MI:SST')