select msgno from actlog where msgno=2565
MSGNO
----------
2565
2565
2565
2565
2565
2565
2565
2565
2565
2565
2565
Mostly useless as is.
Maybe:
select date(date_time) as date,time(date_time) as time, substr(message,10,2)
as deleted \
from actlog where msgno=2565 \
and cast((current_timestamp-date_TIME)minutes as integer) between 0 and
1440
DATE TIME DELETED
---------- -------- ------------------
2002-02-28 00:05:02 0
There are a lot of choices...
> -----Original Message-----
> From: Pothula S Paparao [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 28, 2002 4:15 AM
> To: [EMAIL PROTECTED]
> Subject: How to use string operators in select statement - TSM.
>
>
> Hi TSM'ers
> The below is the message from select output (select * from actlog)
> All I want to know is whether or not possible to caputue only
> the message no (ex. ANR2565I) using select query. I tried using string
> operations in select command. didnt help much. If any select expert tried
this pls let me
> know. Im very much intrested to know about it.
