Sql date related queries(date conversion,get yesterday date)

(1)Get yesterday date
=================================================
DECLARE @COMAPREDATE AS DATETIME=convert(datetime,dateadd(day,datediff(day,1,GETDATE()),0),103)

SELECT CONVERT(VARCHAR(20),@COMAPREDATE,103) AS ReportDate

(2)Difference between conversion date formate(conversion type is datetime and varchar)
=================================================

DECLARE @COMAPREDATE AS DATETIME=convert(datetime,dateadd(day,datediff(day,1,GETDATE()),0),103)

SELECT @COMAPREDATE
out put
------------
2015-07-19 00:00:00.000

DECLARE @COMAPREDATE AS varchar(20)=convert(VARCHAR(20),dateadd(day,datediff(day,1,GETDATE()),0),103)

select @COMAPREDATE



out put
------------
19/07/2015

(3)Get records on particular date in a table
===============================================
DECLARE @COMAPREDATE AS DATETIME=convert(datetime,dateadd(day,datediff(day,1,GETDATE()),0),103

DECLARE @TOTALCOUNT AS INT=0

select @TOTALCOUNT=@TOTALCOUNT+ count(*) from Trans_AppointmentsInfo
where CONVERT(datetime,CreatedOn,103)=convert(datetime,@COMAPREDATE,103)