SQL Server - Como Obtener solo Fecha sin hr:mm:ss

SELECT CONVERT (char(10), getdate(), 112),

CONVERT (char(10), getdate(), 102),

CONVERT (char(10), getdate(), 103)

CREATE PROCEDURE sp_proc_listado_guiasremision

(

 @CodAlmacen as varchar(15),

 @FechaEmision as datetime

)

AS

DECLARE @Fecha as datetime

SET @Fecha =  dateadd(dd, 1, @FechaEmision)

SELECT TipoGuiaRemision,

	   LOC_NroDeSerie,

	   LOC_Correlativo,

	   RTRIM(LOC_NroDeSerie) + '-' + RTRIM(LOC_Correlativo) As Guia,

	   FechaEmision

from GuiasRemision

where LOCNCODE = @CodAlmacen AND

      FechaEmision >= @FechaEmision AND FechaEmision < @Fecha

ORDER BY TipoGuiaRemision, LOC_NroDeSerie, LOC_Correlativo DESC

GO

TipoGuiaRemision LOC_NroDeSerie LOC_Correlativo Guia                  FechaEmision

---------------- -------------- --------------- --------------------- -----------------------

GR               0019           0000008771      0019-0000008771       2014-01-10 17:23:52.000

GR               0019           0000008772      0019-0000008772       2014-01-10 17:24:39.000

(2 row(s) affected)

SELECT CONVERT (char(10), getdate(), 108);

SELECT CONVERT(CHAR(10), FechaSolicitud,108) AS [hh:mm:ss]

	FROM Servicio

	WHERE IdSubEstadoServicio = 2;

ALTER PROCEDURE ControlConfirmacion

	-- Add the parameters for the stored procedure here

AS

DECLARE @leftTime DATETIME

DECLARE @rightTime DATETIME

SET @leftTime = (SELECT CONVERT(CHAR(8), FechaSolicitud,108) AS [hh:mm:ss]

	FROM Servicio

	WHERE IdSubEstadoServicio = 1)

SET @rightTime =getdate()

	-- SET NOCOUNT ON added to prevent extra result sets from

	-- interfering with SELECT statements.

	SET NOCOUNT ON;

    IF DATEDIFF(day, @leftTime, getdate())>24

      BEGIN

            DECLARE Cur_1 CURSOR FOR

			SELECT CONVERT(CHAR(8), @leftTime,108) AS [hh:mm:ss]

			END

OPEN Cur_1

        FETCH NEXT FROM Cur_1 INTO @leftTime

        WHILE @@FETCH_STATUS=1

        BEGIN

    update Servicio set IdSubEstadoServicio = 2 where IdSubEstadoServicio = 1;

END