Blog

SELECT TOP(30) * FROM order_book_tbl WHERE book_price = 35000 
AND LEFT(CONVERT(VARCHAR, CONVERT(datetime, book_order_date, 120), 120), 10) = '2024-02-16'

LEFT(CONVERT(VARCHAR, CONVERT(datetime, book_order_date, 120), 120), 10) = '2024-02-16'