By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,530 Members | 891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,530 IT Pros & Developers. It's quick & easy.

Where clause + VB

P: 19
Why does it say WHERE DATE()>date_destroyed is not a roconized function in VB?

Thanks for the help
May 29 '08 #1
Share this Question
Share on Google+
1 Reply


jeffstl
Expert 100+
P: 432
Why does it say WHERE DATE()>date_destroyed is not a roconized function in VB?

Thanks for the help
That should be part of your SQL string. VB Should not be compiling it.

Nevertheless the SQL date functions do not work like that. You need :

Select CURRENT_TIMESTAMP (or CURRENT_DATE or CURRENT_TIME)

Kind of depends on what you want to do and what kind of database server you are using (Access, MySQL, etc)
May 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.