date time query

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  July 15, 2005 at 7:17 am

  #574785

  I've 6 records with following date 2003-11-03 00:00:00.000 when i run ur second query it returns only 1 record!! i mean

  ISO date format is yyyymmdd so your query should have looked like this

  declare @x varchar(8)

  SET @x ='20031103'

  select taskid,taskname,entrydt from task

  where convert(varchar(8),task.entrydt,112) = @x

  Take note of Jorge's comments about indexes and performance as this type of query will do a table or index scan

   

  Far away is close at hand in the images of elsewhere.
  Anon.

• tzara

  Say Hey Kid

  Points: 663

  More actions

  July 15, 2005 at 2:19 pm

  #575042

  i strongly advise you / everyone to read about datetime handling in books online.

  date and time handling is an extensive topic.