Top "Datepart" questions

SELECT row by DATEPART()

I need to get rows from the database where the records are of one month. I tried this SELECT: $result = …

php mysql sql datepart

Oracle equivalent to SQL Server DATEPART

We need to get the HOUR out of a DATETIME column (expecting values from 0 to 23 to be returned). Is there …

sql oracle date datepart

How to compare two DATE values based only on date part in Oracle?

I am trying to get counts for last 30 days with the following query - SELECT date_occured, COUNT(*) FROM problem …

sql oracle date compare datepart

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

I'm trying to get an SQL query to select all records from last month, I have this which from looking …

mysql sql function datepart

Postgres Time Difference

I am trying to retrieve time difference in minutes from a table(login_history as t1) using postgresql . When i …

postgresql timestamp datepart

Select Where Month= X and Year= Y

I have the following select: SELECT * FROM Table WHERE Column= datepart(month,'2013-05-07 10:18:00') AND Column= datepart(year,…

sql tsql datepart

convert week datepart number to date within week (week of...)

I am trying to figure out how to convert a datepart for a week to the Monday of that week. …

sql tsql sql-server-2005 week-number datepart

SQL change format of Datepart Month

How do you change the DATEPART format of the month to include the 0 in front of the month? For instance 5 …

sql format datepart