What's going on ? You had posted exactly the same message last
month (February 22, to be precise) and at least 4 persons, myself
included, had replied to it, explaining what exactly the SQL is
trying to do. This the message you had posted on 22 February :-

********************************************************************
From: KRISHNAMOORTHY Prabhu Ramachandran [Email address protected]
Sent: Thursday, February 22, 2007 8:22 AM
To: LazyDBA Discussion
Subject: what will be the result for this sql

Hi all,


I am new to oracle iam unable to judge what this below sql does

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


-----Original Message-----
From: KRISHNAMOORTHY Prabhu Ramachandran
[mailto:oracledba-ezmlmshield-x54917323.[Email address protected]
Sent: Friday, March 30, 2007 1:54 AM
To: LazyDBA Discussion
Subject: EXPLANATION FOR THE QUERY

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.
-----------------------------


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page