Home Forums SQL Server 2005 Development SELECT data for today's date RE: SELECT data for today's date

  • March 7, 2011 at 2:48 am

    #1295215

    you could try....

    DECLARE @today VARCHAR(10)

    select @today = convert(varchar(10),getdate(),120)

    then use the parameter in the where clause

    AND T.TimeStarted like @today+'%'

    or just use

    AND T.TimeStarted like (select convert(varchar(10),getdate(),120))+'%'