Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query with ts in date type column

540631Oct 24 2006 — edited Oct 24 2006
select *
FROM WLTUSER.EVALSFO EVALSFO
WHERE (EVALSFO.EVS_RUNSTART>={ts '2006-08-01 00:00:00'})


Can any body tell me what ts stand for. Ihave never seen such compare in date field
FYI
EVS_RUNSTART is date field
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2006
Added on Oct 24 2006
6 comments
682 views