SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[sql] Subtracting Number of Days from a Date in PL/SQL

I would like to subtract a given x number of days from sysdate, can someone assist me on how to do that, I am using the PL/SQL language. THANKS!

This question is related to sql oracle plsql

The answer is

simply,

select sysdate-1 from dual

there's a bunch more info and detail here: http://www.orafaq.com/faq/how_does_one_add_a_day_hour_minute_second_to_a_date_value

Source: Stackoverflow.com

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to plsql

• How can you tell if a value is not numeric in Oracle? • Why do I get PLS-00302: component must be declared when it exists? • Split function in oracle to comma separated values with automatic sequence • PLS-00428: an INTO clause is expected in this SELECT statement • What is the max size of VARCHAR2 in PL/SQL and SQL? • PLS-00201 - identifier must be declared • Default Values to Stored Procedure in Oracle • How to call Oracle MD5 hash function? • Proper way of checking if row exists in table in PL/SQL block • PLS-00103: Encountered the symbol when expecting one of the following: