From SQL Server 2012 you can use the EOMONTH function. Returns the last day of the month that contains the specified date, with an optional offset. Syntax

23 Use the DateValue() function to convert a string to date data type. That's the easiest way of doing this.

25 I have the query below where the date is hard-coded. My objective is to remove the harcoded date; the query should pull the data for the previous month when it runs.

If I have a date 01/01/2009, I want to find out what day it was e.g. Monday, Tuesday, etc... Is there a built-in function for this in SQL Server 2005/2008? Or do I need to use an auxiliary table?

I am using this query to get time taken. SELECT DATEDIFF(dd, ActualStartDate, ActualCompletionDate) AS TimeTaken FROM TableName Now I want to exclude weekends …

I used GETDATE () as a date to work with, you can replace it with the date which you need. Here's how this works: First we format the date in YYYYMMDD... format truncating to keep …

I am using oracle database. I want to execute one query to check the data between two dates.

where A.Date >= '2010-04-01' it will do the conversion for you, but in my opinion it is less readable than explicitly converting to a DateTime for the maintenance programmer that will come after you.

Oldest cdr date - Date format dd/mm/yyyy hh24:mi:ss How can I calcuate the difference in hours minutes and seconds (and possibly days) between the two dates in Oracle SQL?

This question is for sql-server specific, and sql-server doesn't have week() function, so you will need to use datepart() as other answers.