Home Forums SQL Server 2005 Development Need help with DATE should be dynamic for every day summary. RE: Need help with DATE should be dynamic for every day summary.

  • July 3, 2015 at 5:32 am

    #1810175

    AND t.StartExport BETWEEN CAST(left(convert(varchar,CURRENT_TIMESTAMP,120),10)+' 00:01:00.000' AS DATETIME) AND CAST(left(convert(varchar,CURRENT_TIMESTAMP,120),10)+' 16:00:00.000' AS DATETIME)