Hi KMEscherich, The sql is pretty simple for your problem. i created a bteq to test the sql i had created. Below is the bteq execution of your problem. Let me know if this is wht you were looking for....
BTEQ 12.00.00.01 Tue Oct 19 01:19:36 2010
*** Logon successfully completed. *** Teradata Database Release is 12.00.00.10 *** Teradata Database Version is 12.00.00.10 *** Transaction Semantics are BTET. *** Character Set Name is 'ASCII'.
insert into ts values('2006-11-23 15:30:23') ;insert into ts values('2010-09-18 10:15:00') ;insert into ts values('2010-09-05 17:45:00') ;insert into ts values('2010-10-20 19:45:00') ;insert into ts values('2010-10-19 20:29:00') ;insert into ts values('2010-10-21 21:15:00');
*** Insert completed. One row added. *** Total elapsed time was 1 second.