5
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
Use quoation marks around the value.
SELECT *FROM DBO.WHSSHIPMENTTABLE WHERE CARRIERSERVICECODE='T' AND 'MODIFIEDDATETIME= 2021-01-05 14:51:48.000' ORDER BY MODIFIEDDATEANDTIME ASC;
By the way, use Insert > Code (in ther rich formatting view) to paste source code to this forum, as I did.
#1
André Arnaud de Cal...
293,099
Super User 2025 Season 1
#2
Martin Dráb
231,880
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
