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...