Hi all,

Ok it is displaying first day of the current month but how.

Can anyone look into this?


Thanks & Regards

Ravi Kumar Vallemoni
| Tech - Mahindra | Pune |India |Tel: +91 20 66221000 + 1695 | Email:
[Email address protected] |

-----Original Message-----
From: lokesha
[mailto:oracledba-ezmlmshield-x37144894.[Email address protected]
Sent: Friday, March 30, 2007 11:47 AM
To: LazyDBA Discussion
Subject: Re: EXPLANATION FOR THE QUERY

The below query will give the first day of the month on the selected
records.
Ex: if the selected row has the date of 18-Mar-2007, then the below
query
will give 01-Mar-2007.

Try with this query:
SELECT TO_DATE((RTRIM(TO_CHAR(SYSDATE
,'YYYY'))|| '-' ||RTRIM(TO_CHAR(SYSDATE
,'MM'))||'-01')
,'YYYY-MM-DD')
FROM dual ;

TO_DATE((RT
-----------
01-MAR-2007


----- Original Message -----
From: "KRISHNAMOORTHY Prabhu Ramachandran "
<oracledba-ezmlmshield-x54917323.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, March 30, 2007 11:23 AM
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
>
>
>



Disclaimer: This communication is for the exclusive use of the
intended recipient(s) and shall not attach any liability on the
originator or ITC Infotech India Ltd./its Holding company/ its
Subsidiaries/ its Group Companies. If you are the addressee, the
contents of this e-mail are intended for your use only and it shall not
be forwarded to any third party, without first obtaining written
authorization from the originator or ITC Infotech India Ltd./ its
Holding company/its Subsidiaries/ its Group Companies. It may contain
information which is confidential and legally privileged and the same
shall not be used or dealt with by any third party in any manner
whatsoever without the specific consent of ITC Infotech India Ltd./
its Holding company/ its Subsidiaries/ its Group Companies.



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



============================================================================================================================


Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page