SQL query and DATE type field

Forum for DBF Commander discussing.

SQL query and DATE type field

Postby me2 » Thu Jul 01, 2010 6:41 am

When I try exec query like this:

Code: Select all
select * from table1 where date_begin > '25.05.2010' (date_begin is DATE)


program raise error: Operator/operand type mismatch.

What's wrong?
me2
 
Posts: 7
Joined: Mon Feb 07, 2011 11:43 am

Re: SQL query and DATE type field

Postby me2 » Thu Jul 01, 2010 6:47 am

Solution: use {} instead quotes :)

Code: Select all
select * from table1 where date_begin > {25.05.2010}
me2
 
Posts: 7
Joined: Mon Feb 07, 2011 11:43 am

Re: SQL query and DATE type field

Postby Support » Fri Jul 02, 2010 5:30 am

Also, you can use the following:

Code: Select all
select * from table1 where date_begin > CTOD('25.05.2010')
Feel free to ask a question - I'll try to help in anyway!
User avatar
Support
 
Posts: 31
Joined: Mon Feb 07, 2011 10:16 am


Return to DBF Commander Professional

Who is online

Users browsing this forum: No registered users and 8 guests

cron