Error: DATEPART does not exist, frp, SQL to select last months records

mysql sql function datepart
Vereonix picture Vereonix · Dec 1, 2013 · Viewed 20.7k times · Source

I'm trying to get an SQL query to select all records from last month, I have this which from looking numerous places is exactly what I should need, and should work:

SELECT *
FROM orders
WHERE DATEPART(yy,DateOrdered) = DATEPART(yy,DATEADD(m,-1,GETDATE()))
AND DATEPART(m,DateOrdered) = DATEPART(m,DATEADD(m,-1,GETDATE()))

However I keep getting the error:

#1305 - FUNCTION retail.DATEPART does not exist

The query I'm using is word for word from other answers on here, yet I'm getting this error.

Thank you for any help -Tom

Answer

supertopi picture supertopi · Dec 1, 2013

DATEPART is a Transact-SQL function, usable with Microsoft SQL Server. From the question tags, I assume you are using MySQL as your Database Management System.

Take a look at MySQL DATEDIFF

Related questions

MYSQL Function "Error Code: 1242 subquery returns more than 1 row" but I have no subqueries

I don't know what is the problem why it gives me error in running the function Here is my sql: CREATE FUNCTION `test`.`GetProcessorMethodID` (processor_id INT, method_id INT) RETURNS INTEGER BEGIN DECLARE id INT; SET @id := (SELECT `processor_…

Read More
Errors with MySQL stored function creation ERROR 1064 & 1327

I am using MySQL v5.1.36 and I am trying to create a stored function using this code. DELIMITER // CREATE FUNCTION `modx`.getSTID (x VARCHAR(255)) RETURNS INT DETERMINISTIC BEGIN DECLARE y INT; SELECT id INTO y FROM `modx`.coverage_state WHERE `…

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More