Oracle : How To show/ get First Date of the Month ?

January 7th, 2013, posted in Oracle
Share

If you want to show or if you need the month first day, last time I check there was no built-in function in Oracle. But you can get it easily by using some other single-row date function. Here bellow an example of this.

SELECT LAST_DAY(ADD_MONTHS(SYSDATE,-1))+1
FROM DUAL;

Run the above sql and you will get the first day of current month.

For last day of current month just use the LAST_DAY function like this LAST_DAY(SYSDATE)

Need more help ? Just Leave you comments…

*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
 well.
*********************************************************************************************************************
Share

Coakroach Power

January 6th, 2013, posted in COMiCS
Share

Flying Coakroach

Share

Oracle : Display Current Date

January 5th, 2013, posted in Oracle
Share

Go to column properties then set initial value $date$ for user machine sysdate or use$dbdate$ for server machine sysdate.

If need sysdate with time then write $datetime$ or $dbdatetime$

*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
 well.
*********************************************************************************************************************
Share

Do Not Force Your Children To Behave Like you

January 4th, 2013, posted in Islamic Teachings, Saying Of Hazrat Ali ( A.S )
Share

saying of wise man

Do Not Force Your Children To Behave Like you, For Surely They Have Been Created For a time Which Is Different To Your Time. —-

Hazrat Ali (A.S)

Share

The Resting Place Of Jaun Elia

January 3rd, 2013, posted in Jaun Elia
Share

Gum sum Aankhen sooni Sansen toot’ti jurti umeedain..

Darta hoon u’N kaise ktey gi? Umar hai, koi raat nahi….

The Resting Place Of Jaun Elia

Share