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

**URL:** <https://forums.toadworld.com/t/sql-query-runs-fine-in-toad-but-not-on-unix-sqlplus-defined-as-date/9545>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 26, 2010, 9:02am UTC](https://forums.toadworld.com/t/sql-query-runs-fine-in-toad-but-not-on-unix-sqlplus-defined-as-date/9545 "2010-05-26T09:02:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 26, 2010, 9:02am UTC](https://forums.toadworld.com/t/sql-query-runs-fine-in-toad-but-not-on-unix-sqlplus-defined-as-date/9545/1 "2010-05-26T09:02:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 26, 2010, 9:02am UTC](https://forums.toadworld.com/t/sql-query-runs-fine-in-toad-but-not-on-unix-sqlplus-defined-as-date/9545/2 "2010-05-26T09:02:22Z")

</div>

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

* * *