Home Forums SQL Server 7,2000 T-SQL Date Function RE: Date Function

  • June 24, 2003 at 12:31 am

    #462732

    Try using the "between" Operator.

    For example in Pubs Database

    select * from pubs..sales where ord_date between '1994-09-13 00:00:00.000' and '1994-09-14 00:00:00.000'