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

Retrieve date now

P: 7
Hi,

I need to extract some data for todays date, my query is something like this:

SELECT client,
apar_id,
voucher_no,
trans_date

FROM asutrans
WHERE client = '01'
and voucher_type = 'AP'

and I need to extract all those transactions that have been posted today. I've tried adding on the end of my select statement ' and trans_date = now() ' or ' and trans_date = 'getdate' etc

Does this make sense, and can anyone help?

Many Thanks
Sep 15 '09 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
This is how SQL Programmers search for dates.

Good luck!!!

--- CK
Sep 15 '09 #2

Post your reply

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