Escape sequences in Forms? (dynamic SQL)

I'm trying to modify a package written by someone else, in a pre-Y2K frame of mind. The package accepts three dates (start date, end date, report date) to print a report listing all of the invoices between the start and end dates.

What I want to do is convert the date code in the dynamic SQL, and mask it.

CURRENT CODE:
v_qry := 'SELECT ... '

|| 'invoice_date, ... '

CODE I WANT TO IMPLEMENT:
v_qry := 'SELECT ... '

|| 'to_date (to_char (invoice_date, 'MM/DD/YYYY'),
'MM/DD/"19"YY'), ... '

Any insight you could provide would be greatly appreciated.

Regards,
--Julius

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 12 2000 - 21:25:22 CET