below is the original code
convert(datetime,
(substring(convert(varchar(26),
convert(datetime,getdate())),1,12) +
'23:59:59:996'))
output is = 6/17/2015 11:59:59.996
I converted it to Teradata below
CAST(CURRENT_TIMESTAMP AS DATE FORMAT 'MM/DD/YYYY') || ' 23:59:59:999990'
but upon compiling my store proc, it produces an error below
Invalid or missing expression 'E(5404):Datetime field overflow.'.
Is there a command in Teradata to set the day into midnight?
Thanks