-2

I have got data from table. There is one datetime field in table. Field name is createdon

In select query I pass two datetime parameters Now I want all data from table where createdon field is not equals to these two date time parameters.

Abubakkar
  • 15,488
  • 8
  • 55
  • 83
user1817367
  • 43
  • 1
  • 1
  • 5
  • Please add your statement. It seems as you are passing the parameters in wrong format. – Kai Nov 16 '12 at 10:28

1 Answers1

3

A literal interpretation.

SELECT *
  FROM TBL
 WHERE createdon NOT IN (@date1, @date2);
RichardTheKiwi
  • 105,798
  • 26
  • 196
  • 262