This was an Oracle thread ... you are correct ... those functions are not valid in SQL Server ...

however: .... how about try getdate()-1