HI ALL,


CaN ANY ONE GIVE ME A CLEAR EXPL FOR THE BELOW QUERY




SELECT TO_DATE((RTRIM(TO_CHAR(SYSDATE
,'YYYY'))|| '-' ||RTRIM(TO_CHAR(SYSDATE
,'MM'))||'-01')
,'YYYY-MM-DD')
FROM ps_installation


Thanks
Prabhu Ramachandran Krishnamoorthy

Confidentiality Statement:

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.
-----------------------------

Oracle LazyDBA home page