Teradata Basic command on Date & Time

1.To select date
Select Date

2.To select time
Select time

3. To find the number of days between two date
select (date '2006-12-31'- date '2006-01-01' );