Top "Datediff" questions

Date-difference will give difference in the number of days, months, years etc.

SQL DATEDIFF Not working?

I am running a simple DATEDIFF query but it doesn't seem to calculate the days properly or i'm doing something …

sql tsql datediff
Is timestampdiff() in MySQL equivalent to datediff() in SQL Server?

I am working on migrating functions from SQL Server 2000 to MySQL. The following statement executed in SQL Server 2000, gives the …

mysql sql-server sql-server-2000 datediff
What is the recommended way of doing date arithmetics in Perl?

What is the recommended way of doing date arithmetics in Perl? Say for example that I want to know the …

perl datetime cpan datediff date-arithmetic
Conversion Hive datediff() to months

When using Hive there is the functionality to return the select datediff('date1','date2') from table value which …

sql date hadoop hive datediff
SQLite: express the difference as days, hours, minutes between two given dates

I am trying to express the difference of two given dates in days, hours, and minutes (like 1 day, 6 hours, 17 minutes.) …

sqlite datetime datediff
Difference between two dates, including only business days (i.e. excluding weekends and holidays)

How can I get the number of business days between two java.util.Date, i.e. excluding weekends and holidays? …

java date datediff
Between older than 30 days and less than 90days

I need to return records where there is a date older than 30days but less than 90days. so If someone …

sql-server-2008 datediff getdate
Updating year in datetime variable

I'm playing around with manipulating a datetime variable. I can't seem to find a way to update a datetime variable …

sql-server datetime datediff
Athena DateDiff

I am trying to do what I think is a simple date diff function but for some reason, my unit …

datediff presto amazon-athena
Deleting records having a date older than 3 days, for rolling 3 day job?

Prior to executing a sensitive sql command I wanted to do a sanity check. I am trying to delete records …

sql-server-2005 datediff sql-delete