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

Contributors

4 Hours

Discussion Span

1 Year Ago

Last Updated

Views

Question
Answered

wezel

Newbie Poster

9 posts since Dec 2005

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

1 Year Ago

Try now()

adam_k

Veteran Poster

1,057 posts since Jun 2011

Reputation Points: 274

Solved Threads: 205

Skill Endorsements: 11

Question Answered as of 1 Year Ago by adam_k

This question has already been solved: Start a new discussion instead

You