Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Brian Syverson How to Search for Date and Time Values RE: How to Search for Date and Time Values

  • January 21, 2003 at 12:03 am

    #446822

    hi abhi_develops,

    I mean something like this, it obviously is not an efficient way. Just another method

    ex:

    SELECT CONVERT(varchar, dateEntered, 103)

    FROM dbo.tblDirectory

    WHERE CONVERT(varchar, dateEntered, 103) LIKE '09/07/2002%'