specify teradata date literal

'YYYY/MM/DD' as

 select top 10 * from Pushrpt_Views.PR_Property where report_dt='2011/08/31'

'YYYY-MM-DD' ANSI date as

 select top 10 * from Pushrpt_Views.PR_Property where report_dt='2011-08-31'