Current date in C/ODBC

r_schueler

Hello,

how to select the current date with C/ODBC-SQL ?

I want to create a query like this:
select * from customers where insert_date = TODAY;
How is the right syntax for TODAY?

The second question is how to concatenate two fields in a
query like this "select text_1 + text_2 form table;"

Best regards
Rainer

wbenefiel

Try:
select * from customers where insert_date = Date();

---

Bill Benefiel
NCPS,NCSD
Manager of Information Systems
Overhead Door Company of Indianapolis
billb@ohdindy.com

paul

why doenst this work?
i'm tryin an odbc/sal query with microsoft query
but i'm having trouble with dates:

SELECT * FROM Klantenpost
WHERE Boekingsdatum=date();

its always giving
unexpected token: )

i tried a series of variations but none works