Problem in SQL query in MDB database

[Ranjeet_Singh]

Hello all,

                    I am using mdb database and want to read specific time stamp record based on time stamp. I am using simple sql query but I am getting one error. Please let me know where I am making mistake(s). One error is operator missing. VI and database is attached.

My query is -SELECT * FROM Downloaded_120 where col2 between 13:00:00 04-06-2013 and 14:00:00 04-06-2013

Thanks.

[jcarmody]

http://digital.ni.com/public.nsf/allkb/4012B21BA0876907862576110070FC0A

You're missing the #s, too.

[Ranjeet_Singh]

Thanks, it works perfectly.

[nyc_(is_out_of_here)]

---

@Ranjeet_Singh wrote:

Thanks, it works perfectly.

---

Then you should mark this thread as solved and perhaps give a Kudo.