Top "Datediff" questions

SQL Datediff - find datediff between rows

I would like to query a database using sql to show the difference in time between id 1,2,3 and so on. …

sql sql-server tsql datediff

Sharepoint Designer - is there a way to calculate a date difference in a workflow?

Maybe I'm just crazy... So, with SPD I can add any time unit to a date and put that into …

sharepoint date workflow sharepoint-designer datediff

Calculating difference of dates In Postgresql

I'm trying to find out the time between certain fields in my tables. However cause I'm using Postgresql :(( I can't …

sql postgresql datediff

SSRS 2008 Datediff for Working Days

I have seen this question asked a lot and I cannot seem to find one clear answer about "how to …

ssrs-2008 datediff

Difference between two dates in dates using Google bigquery?

How can I get the difference in days between 2 timestamp fields in Google Big Query? The only function I know …

sql google-bigquery datediff date-difference

How to convert given number of days to years, months and days in MySQL?

I am trying to get the date and time duration between the Loan taken and Paid date. I used the …

php mysql datetime datediff

Pyspark: Difference between two Dates (Cast TimestampType, Datediff)

There is a table with incidents and a specific timestamp. I struggle to calculate the number of days passed using …

timestamp pyspark datediff

What is the most straightforward way to pad empty dates in sql results (on either mysql or perl end)?

I'm building a quick csv from a mysql table with a query like: select DATE(date),count(date) from table …

mysql perl calendar datediff

Trigger with a RAISERROR and ELSE case issue

I am trying to make a bit of code that takes in 2 separate columns, a month and a year. From …

sql-server triggers datediff raiserror

Difference in Days between two Java dates?

I want to get the difference between two Java Date objects. I've used Joda-Time library. But the problem is that …

java jodatime datediff