Oracle 10 Query by Unix Sysdate

[Harald V]

Hi,
i like to do a query that shows me all added lines to a table at the end of the day (used for storing a repository file list).

At 23:59 i like to invoke a cron job script that makes a query.

Inside the table i have a 2 collums, one is NAME1, the other is INSERTED_DATE – this line is a DATE formatted DD-Mmm-YYYY eg.: 16-Sep-2011

I like to convert this to match my Solaris System Date and output the list of NAME1

Something like:

select NAME1 from TABLE1 where trunc(INSERTED_DATE) = (trunc)sysdate;

Does that work, or can I also use a variable I set before I login to the db earlier in my shell script – in that case I can set a date variable in solaris using the same format then the oracle used date. But how to I compare to a unix variable?

Earlier in the script I defined: date="date '+%e-%b-%Y'"

Now, at least in the solaris shell, $date is 16-Sep-2011 – can I use that in the query?