Skip to main content

How to get first day and last day Of the current and Previous year on Oracle

Get current year :
SELECT TO_CHAR(SYSDATE, 'YYYY')  AS Current_Year FROM DUAL;

First Day of Current Year:

SELECT TO_CHAR(TRUNC (SYSDATE , 'YEAR') ,'DD/MM/YYYY') FROM DUAL;

Last Day of Current Year:

SELECT TO_CHAR(ADD_MONTHS(TRUNC (SYSDATE ,'YEAR'),12)-1,'DD/MM/YYYY')  
      AS LastDay_Current_Year 
FROM DUAL;

First Day of Previous Year:

SELECT TO_CHAR(ADD_MONTHS (TRUNC (SYSDATE,'YEAR'), -12),'DD/MM/YYYY')  
   AS FirstDay_Previous_Year 
FROM DUAL;

 Last Day of Previous Year:


SELECT TO_CHAR(ADD_MONTHS (TRUNC (SYSDATE, 'YEAR'), -1 ) +30 ,'DD/MM/YYYY')  
     AS LastDay_PreviousYear
FROM DUAL;

Comments

Popular posts from this blog

What are the difference between DDL, DML , DCL and TCL commands?

Database Command Types DDL Data Definition Language  (DDL) statements are used to define the database structure or schema.  -           CREATE - to create objects in the database -           ALTER - alters the structure of the database -           DROP - delete objects from the database -           TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed -           COMMENT - add comments to the data dictionary -           RENAME - rename an object DML Data Manipulation Language  (DML) statements are used for managing data in database. DML commands are not auto-committed. It means changes made by DML command are not permanent to d...

Ubuntu/Unix Console Command -Cheat Sheet

M ost popular Linux/Unix command those are required to know during working on Linux/Unix environment. Primarily, when I started the work on ubuntu, I faced a common problem that was not familiar to know about the basic ubuntu command. After that, I aggregate basic commands and work very well. Besides that, most of the time forgot the command and this helps me to cut-down googling time. Privileges SL Command Use / Description 1 sudo command Run command as root 2 sudo -s Open a root shell 3 sudo -s -u user Open a shell as user 4 sudo -k Forget sudo passwords 5 gksudo command Visual sudo dialog (GNOME) 6 kdesudo command visual sudo dialog (KDE) 7 sudo visudo edit /etc/sudoers 8 gksudo nautilus root file man...

Display Image Immediately from fileUpload Control

Client Side Programming is more efficient for user to very first interection Like Jquery . Now i provide some jquery script to display Image from FileUpload Control directly.. For this purpose we use reference . <script src="../../../JS/JQueryAutocomplete/jquery-1.7.2.js" type="text/javascript"></script>. You just download from jquery.com. Now code below... <script language="javascript" type="text/javascript"> /* Write FileUpload Change event .. */ $('#FileUpload1').bind('change', function() {                                 displayImage(this);                    }); //-------------------------// function displayImage(input)             {        ...