Today's Date SQL

[wezel]

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

[adam_k]

Try now()