ASP - MSSQL 날짜 검색 쿼리 (convert 미사용/사용)

    query = ""
    query = query & "update digitalsky_order_coupon "
    query = query & "set USE_CHK = 'OK', "
    query = query & "USE_DATE = '"& RESULT_DATE &"' "
    query = query & "where BUY_DATE >= '"& RESULT_DATE &" 00:00:00' "
    query = query & "or "
    query = query & "BUY_DATE <= '"& RESULT_DATE &" 23:59:59'"
    db.Execute(query)

    query = ""
    query = query & "  "
    query = query & " select "
    query = query & " * "
    query = query & " from dukgu_order "
    query = query & " where "
    query = query & " 1=1 "
    query = query & " and "
    query = query & " convert(varchar(10), buy_date, 120) >= '"&buy_date&"' "
    query = query & " and "
    query = query & " convert(varchar(10), buy_date, 120) <= '"&buy_date&"' "