Retrieve date now

[lornab]

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

[ck9663]

This is how SQL Programmers search for dates.

Good luck!!!

--- CK