sybase to oracle

philmalmaison · Post by **philmalmaison** » 16 Mar 2010 4:16

does anybody know how can i translate the following sybase/SQL command to oracle ?

select XTIME,' | ',MESSAGE from EXCEPTION_ALERTS
where
XTIME >= dateadd (mi,-31,getdate())
and
COMPONENT_TYPE != 0
and
MESSAGE not like '%GCS%Condition=%'

thanks for any help

regards
philmalmaison

GNappo · Post by **GNappo** » 18 Mar 2010 10:26

Hi Philmalmaison,

if I well remember, it could be:

XTIME >= sysdate -31

Best Regards

Giuseppe Nappo

philmalmaison · Post by **philmalmaison** » 22 Mar 2010 3:45

no the answer is

XTIME >= (SYSDATE-INTERVAL'31'MINUTE)

regards
philmalmaison