InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 06:01:45 GMT20http://www.sqlservercentral.com/Forums/Topic1031099-145-1.aspx@John , it would work but its not SARGable. Or at least the date is not, which is what we are interested in here.See the link i gave previously which describes this.Mon, 07 Mar 2011 05:36:49 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic1031099-145-1.aspxHi,Would the following not work:SELECT s.TaskID, t.TaskName, T.TimeStarted, s.Action, s.SourceHost As Source_File_Location, s.DestFileName As Destination_FileName, t.Success, t.LastErrorTextFROM Stats SJOIN Taskruns T ON S.TASKID = T.TASKID WHERE Success not like 'No xfers' AND Success like 'Failure' AND Action not like 'Process' AND convert(datetime,convert(varchar(12),T.TimeStarted)) = (select convert(datetime,convert(varchar(12),getdate())))ORDER BY T.TimeStarted DESCthis essentially puts the Timestarted and getdate in the same format, which although it inserts the time, makes it 00:00.000 on both sides of the clause.Regards,JohnMon, 07 Mar 2011 05:33:47 GMTjohn.richardshttp://www.sqlservercentral.com/Forums/Topic1031099-145-1.aspxyou could try....DECLARE @today VARCHAR(10)select @today = convert(varchar(10),getdate(),120)then use the parameter in the where clauseAND T.TimeStarted like @today+'%'or just useAND T.TimeStarted like (select convert(varchar(10),getdate(),120))+'%'Mon, 07 Mar 2011 02:48:47 GMTFai Ho Fuhttp://www.sqlservercentral.com/Forums/Topic1031099-145-1.aspxPlease see this link[url]http://www.karaszi.com/SQLServer/info_datetime.asp[/url]Tue, 07 Dec 2010 03:43:32 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic1031099-145-1.aspxHi, The latter, the display format of a datetime is as shown.The column is of Varchar(24) data type.When I insert the lines you have provided I get the error:Msg 102, Level 15, State 1, Line 17Incorrect syntax near '>'.[code="sql"]SELECT s.TaskID, t.TaskName, T.TimeStarted, s.Action, s.SourceHost As Source_File_Location, s.DestFileName As Destination_FileName, t.Success, t.LastErrorTextFROM Stats SJOIN Taskruns T ON S.TASKID = T.TASKID WHERE Success not like 'No xfers' AND Success like 'Failure' AND Action not like 'Process' AND (T.TimeStarted => DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) -- 2010-12-07 00:00:00.000 AND T.TimeStarted < DATEADD(dd, 0, 1 + DATEDIFF(dd, 0, GETDATE()))) -- 2010-12-08 00:00:00.000ORDER BY T.TimeStarted DESC[/code]Tue, 07 Dec 2010 03:35:59 GMTA Little Help Pleasehttp://www.sqlservercentral.com/Forums/Topic1031099-145-1.aspxWhat is the type of the column TimeStarted? Is it a string or datetime?AdiTue, 07 Dec 2010 03:29:50 GMTAdi Cohn-120898http://www.sqlservercentral.com/Forums/Topic1031099-145-1.aspx[quote][b]A Little Help Please (12/7/2010)[/b][hr]I have a table which has a column called TimeStarted.The formate of the date in this column is YYYY-MM-DD HH:MM:SS[/quote]Are you saying the column holds a character-type representation of a date, in this format, or the display format of a datetime is as shown? Assuming the latter, then the following will work:[code="sql"] AND (t.TimeStarted >= DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) -- 2010-12-07 00:00:00.000 AND t.TimeStarted < SELECT DATEADD(dd, 0, 1 + DATEDIFF(dd, 0, GETDATE()))) -- 2010-12-08 00:00:00.000[/code]Edit: changed '=>' to '>='Tue, 07 Dec 2010 03:23:03 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1031099-145-1.aspxI have a table which has a column called TimeStarted.The formate of the date in this column is YYYY-MM-DD HH:MM:SSI want to do a SELECT against this table which ONLY pulls back data for today's date. I have tried the following and it does not bring back any data:[code="sql"]SELECT s.TaskID, t.TaskName, T.TimeStarted, s.Action, s.SourceHost As Source_File_Location, s.DestFileName As Destination_FileName, t.Success, t.LastErrorTextFROM Stats SJOIN Taskruns T ON S.TASKID = T.TASKID WHERE Success not like 'No xfers' AND Success like 'Failure' AND Action not like 'Process' AND T.TimeStarted like (select convert(varchar(10),getdate(),120))ORDER BY T.TimeStarted DESC[/code]Tue, 07 Dec 2010 03:12:41 GMTA Little Help Please