Top "Dateadd" questions

How to add days to the current date?

I am trying to add days to the current date and it's working fine but when I add 360 days to …

sql-server dateadd

Add 'x' number of hours to date

I currently have php returning the current date/time like so: $now = date("Y-m-d H:m:s"); What I'd like …

php date datetime dateadd hour

How to select last one week data from today's date

How to select week data (more precisely, last 7 days data) from the current date in the fastest way as I …

sql-server-2008 dateadd

Subtract minute from DateTime in SQL Server 2005

Suppose I have a datetime field whose value is 2000-01-01 08:30:00 and a duration field whose value is say 00:15 (meaning 15 …

sql-server tsql datetime sql-server-2005 dateadd

MySQL - DATE_ADD month interval

I face a problem with the function DATE_ADD in MySQL. My request looks like this : SELECT * FROM mydb WHERE …

mysql sql select dateadd

How to add minutes to the time part of datetime

How to add minutes(INT) to the time part of datetime ? For example : If i have datetime variable like this : @…

sql sql-server datetime time dateadd

DATEADD equivalent in PostgreSQL

Is there an equivalent to this T-SQL command in PostgreSQL? select dateadd(hh,duration_in_hours,start_date) as end_…

postgresql equivalent dateadd

Using Parameters in DATEADD function of a Query

I am trying to us the DateAdd function of SQL in my Query. The problem is when I use a …

sql-server parameters dateadd

Adding one year to a date field in postgresql

I have a table in postgresql with a field_date using the syntax 'YYYY-MM-DD', I want to add a year …

postgresql date dateadd

How to subtract one month from a Date Column

I know about Dateadd and datediff, but I cannot find any information how to use these functions on an actual …

sql sql-server dateadd