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

How to check dotnet SDK and runtime version installed

I need to install dot net SDK 5 but first, I need to know which versions of SDK installed on my system. So, use   dotnet --info .  This command will display the SDKs and also runtimes installed on your system with path together where they are installed. For example on my Windows 10 development machine,  dotnet --info   Microsoft Windows [Version 10.0.18363.1082] (c) 2019 Microsoft Corporation. All rights reserved. C:\WINDOWS\system32>dotnet --info .NET Core SDK (reflecting any global.json):  Version:   3.1.101  Commit:    b377529961 Runtime Environment:  OS Name:     Windows  OS Version:  10.0.18363  OS Platform: Windows  RID:         win10-x64  Base Path:   C:\Program Files\dotnet\sdk\3.1.101\ Host (useful for support):   Version: 3.1.8   Commit:  9c1330dedd .NET Core SDKs installed:   1.0.0-preview2-003131 [C:\Program Files\dotnet\sdk...