Top "Dateadd" questions

When I enter a dateadd or datediff code i get this error all the time "ORA-00904 "DATEADD" INVALID IDENTIFIER."

I have a university project and I have a patient table with admission and discharge date attributes. I need to …

sql oracle oracle11g sqlplus dateadd

MySQL: DATE_ADD

Is there a difference between: SELECT DATE_ADD('2005-01-01', INTERVAL 3 MONTH); and SELECT '2005-01-01' + …

mysql dateadd

Add Number of days column to Date Column in same dataframe for Spark Scala App

I have a dataframe df of columns ("id", "current_date", "days") and I am trying to add the the "days" …

scala apache-spark dataframe dateadd

SQL Query Subtract 1 month

I need to query SQL for data that falls into a last month date. I thought I was using the …

sql dateadd

How to get week ending date of a given date returned from a DateAdd expression

Not sure how to take my current expression and get the week ending date of the week. My current expression …

sql-server dateadd

Assign T-SQL variable from CASE statement referencing previously declared variables

I am attempting to dynamically define a time period for a query and am running into an issue while converting …

sql sql-server reporting-services case dateadd

Using DATE_ADD with a Column Name as the Interval Value

I have a table which contains products, a start date and an interval value : product_name start_date expiry_period …

mysql sql dateadd

INSERT INTO SQL DATEADD Yesterday

I want to use PHP and MySQL to INSERT the the day of Yesterday. So my idea was: INTO chartValues …

mysql dateadd

DATEADD(day, -7, GETDATE()) - Does it take time into account?

I am writing a SQL query in Aginity through Amazon Redshift to extract the last 7 days of data. The Date …

sql-server tsql date dateadd

MySQL DATE_ADD INTERVAL

mysql_query("UPDATE tablename SET date = DATE_ADD(DATE(NOW() + INTERVAL 1 WEEK), INTERVAL 17 HOUR), INTERVAL 30 MINUTE) WHERE idevent = '2'") …

mysql intervals dateadd