Insert sysdate value to date type column in DB
795014May 3 2011 — edited May 3 2011Hi All
I need you help. How to set Last_Update_Date to a default date in sql… For example when a user runs the query, the query show display only those values which got changed as of that day’s date. For Example. If I run the query on May 22nd the query show display only that data which got last updated on May 22nd.Can we use INSER INTO. If so ow to insert Last_update_date = sysdate in the below query.
select hzp.creation_date,fnd.user_id,hzp.party_id,fnd.user_name,
hzp.person_first_name,hzp.person_last_name,hzl.address2,hzl.address3,hzl.city,
hzl.postal_code,hzl.state,hzp.last_update_date,frt.responsibility_name
from APPLSYS.fnd_responsibility_tl frt,APPS.fnd_user_resp_groups fur,
APPLSYS.fnd_user fnd,AR.hz_parties hzp,AR.hz_party_sites hzps,AR.hz_locations hzl
where fnd.user_id = fur.user_id
and fur.responsibility_id = frt.responsibility_id
and hzp.party_id = fnd.person_party_id
and hzp.party_id = hzps.party_id
and hzps.location_id = hzl.location_id
and last_updated_date = ''
Regards