Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 694
  • Last Modified:

what is my mistake In this query ( "select SYSDATE as curDate from dual")

Hi all

what is my mistake In this query ( "select SYSDATE as curDate from dual")

when I make run for my project I get this error (look at the Pic)



MS-Error.jpg
0
SystemSys
Asked:
SystemSys
  • 2
1 Solution
 
SystemSysAuthor Commented:
note :
I use Microsoft Office Access & VB.net 2008
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
SYSDATE is a function in oracle, but not in access.
in access, use NOW() function (for date+time) or DATE() for date only)
0
 
SystemSysAuthor Commented:
Thanks angelIII
Excellent
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now