I HAVE A TABLE NAMED WHSSHIPMENTTABLE WHICH CONSISTS OF FIELD CALLED MODIFIED DATE AND TIME
I NEED TO WRITE A QUERY TO FILTER DATA ON PATICULAR DATE N TIME
THIS IS WHAT I WROTE:
SELECT *FROM DBO.WHSSHIPMENTTABLE WHERE CARRIERSERVICECODE='T' AND MODIFIEDDATETIME= 2021-01-05 14:51:48.000 ORDER BY MODIFIEDDATEANDTIME ASC;
it says syntax error near 14:51:48