How To Get Previous DATE in SQL - SQL previous date

-

 Let's think of a scenario in which you want to get the previous date (the date before today) in SQL here is the query to get that.


Oracle - Get previous date in Oracle

You can use SYSDATE to get the current date. Then subtract 1 day from the current date.

SELECT SYSDATE - 1 FROM dual;

 



MySQL - Get previous date in Oracle

Get the current date using CURDATE() and you can use DATE_SUB() to subtract the date and you can use DATE_ADD() to add the date.

If the current date is 2023-12-18,

SELECT DATE_SUB(CURDATE(), INTERVAL 1 DAY);


 You can get the tomorrow date using DATE_ADD().

SELECT DATE_ADD(CURDATE(), INTERVAL 1 DAY);


 


MSSQL - Get previous date in Oracle

You can use GETDATE() to get the current date and you can use DATEADD() to subtract the date.

SELECT DATEADD(DAY, -1, GETDATE());

 



 

Comments

Post a Comment

Popular posts from this blog

Introduction To MongoDB

-
  What is MongoDB? MongoDB is a NoSQL document-oriented database. MongoDB is written by using C++ language. NoSQL databases are much different than relational databases. In a real database, you have to map out everything. You need to figure out the exact schema what table you use and what field you use and all that stuff. But with NoSQL, there is not like that. You should plan out the structure of your database and your collections. But you don’t have to do any free structuring before you build your application. An advantage is MongoDB is easy to scale. MongoDB uses documents containing key-value pairs to store data. A collection is a group of MongoDB documents. MongoDB uses collections instead of tables and uses documents instead of rows and uses fields instead of columns.   MongoDB Syntax MongoDB uses use database_name syntax to create a database   Create a collection Collections hold documents or record...
Read more

Introduction To React JS

-
Image
  React JS React js is a JavaScript library that we use to create the user interface of single page application. A single page application is a web application that dynamically rewrites the current page with new data without loading a new page. React JS is developed by the Facebook company. The top 3 main companies that use React JS are Facebook, Instagram, and WhatsApp. When developing an app using react js, the app is separated into parts called “component”. Props Props are properties/arguments passed into React component. Props are send into a component as HTML attributes. Ex:- < Person name =" John " />   State A state is an object that stores props values that belongs to the component. State is used to keep props data that can be updated. Ex:-   class Person extends React . Component {   constructor ( props ) {     super ( props );     this . state = { name : "John" };   } We can use...
Read more