Toad World® Forums

SQL query runs fine in TOAD, but not on UNIX (sqlplus) [defined as DATE]


#1

SQL query runs fine in TOAD, but not on UNIX
(sqlplus) [defined as DATE]


#2

Hi
Try this

SELECT serial
|| ‘;’
|| upd_time
|| ‘;’
|| MESSAGE
|| ‘;’
|| entity_table
|| ‘;’
|| action
|| ‘;’
|| status
|| ‘;’
|| act_msg
|| ‘;’
|| rss_name
|| ‘;’
|| rss_type
|| ‘;’
|| ADMIN
FROM trans
WHERE ess_user = ‘suite_admin_sharepoint’ AND upd_time > to_date(‘25/05/2010’,‘DD/MM/YYYY’)
ORDER BY serial DESC;

Rob Silver
Marketing Analyst
HSDL