select ((current date-(dayofweek(curr ent date)-1)days)-6 days)as last_monday,
(current date-(dayofweek(curr ent date)-1)days) last_sunday
from sysibm.sysdummy 1
arjunsinghsamant
Last Activity: Feb 16 '10, 04:16 AM
Joined: Jan 28 '10
Location:
-
select * from tm where LASTUPDATETIMES TAMP in(select max( LASTUPDATETIMES TAMP) from tm)
try this !!!Leave a comment:
-
replace that :
select replace(substr( replace(substr( 'ABCD$defg',1), '$','r'),1,9),' r','$') from sysibm.sysdummy 1
is it works well as per ur need?Leave a comment:
No activity results to display
Leave a comment: