Today's Date SQL

Hello,

I am trying to query a table for todays date based on this format mm/dd/yyyy hh:mm:ss AM/PM
I tried date() but it only returns results based on the mm/dd/yyyy formate. Any assistant is apprecaited!

Thanks,
Wez

microsoft-access

Contributors

Views

5 Years

Discussion Span

5 Years Ago

Last Post by adam_k

This Question has been Answered

Try now()

This question has already been answered. Start a new discussion instead.

Hello all members,
I am new to this this website. I am working on an assignment and I have a scenario where I have to find the key attributes, entities ...

I receive an error message and I don't know what to do about it.
IO have a delphi app using a MS Access 2010 database. I connect to it through ...

Hi every one .
i need code for how i set the connection i.e when i execute the project .exe it show me a form in which there is Database ...