date-arithmetic Examples and Free Source Code

MySQL how to fill missing dates in range?...

mysql sql recursive-query gaps-and-islands date-arithmetic

How to get previous week using YEARWEEK in sql?...

mysql sql datetime where-clause date-arithmetic

How can I capture date intervals dynamically using recursion or another method in Redshift?...

sql amazon-redshift recursive-query date-arithmetic

Is there a way to use BigQuery's DAYOFWEEK but with Monday as its first day?...

sql google-bigquery date-arithmetic

aggregation of aggregation not allowed...

sql google-bigquery aggregate-functions date-arithmetic

Get dates of previous 3 months from the current month in Oracle Sql...

sql oracle-database date where-clause date-arithmetic

SQL: Is it possible to SUM() fields of INTERVAL type?...

sql-server oracle-database t-sql plsql date-arithmetic

What is the minimum odd number representable in a 32-bit float, written in both decimal and binary?...

floating-point binary numeric date-arithmetic integer-arithmetic

SQL Server version of Oracle's ADD_MONTHS()...

sql sql-server oracle-database date-arithmetic

Calculating the average session length in PostgreSQL...

sql postgresql window-functions date-arithmetic

how to add previous rows for all dates based on some ID if data does not exist in SQL...

sql sql-server subquery date-arithmetic

Round timestamps to the nearest half hour without omitting missing data...

sql mysql query-optimization recursive-query date-arithmetic

datediff in Hive resulting in Invalid number of arguments error...

sql apache-spark hive date-arithmetic

Calculating Job finish time...

sql sql-server date-arithmetic

Return the number of records where condition met within time intervals in MySQL...

sql mysql aggregate-functions date-arithmetic

PostgreSQL Transition: Comparing Timestamps to days...

sql postgresql date-arithmetic

How to write "streak" query?...

sql sql-server common-table-expression gaps-and-islands date-arithmetic

default the end date based on previous week's last date...

sql mysql where-clause date-arithmetic

Facing different outputs from below two codes...

sql case date-arithmetic

In SQL: How to concat hour and minute (stored as integers in a separate column) with the date part o...

sql postgresql date-arithmetic

Athena - Add a Row with 0 for All Columns if a Value is Not Present...

sql case amazon-athena presto date-arithmetic

SQL Query for Counting Consecutive Reservations...

mysql sql subquery aggregate-functions date-arithmetic

Find record which are greater or equal to 30 days from previous record...

sql sql-server recursive-query date-arithmetic

Find average time between records...

sql google-bigquery aggregate-functions date-arithmetic

Group by 15 minutes increments with a count, including counts of 0...

sql oracle-database datetime recursive-query date-arithmetic

Sum values based on Unique values in other column...

sql google-bigquery aggregate-functions date-arithmetic

how to query current week and month data with `SQL` in MySQL?...

mysql sql aggregate-functions date-arithmetic

get no of new users per month using sql and python...

python sql postgresql aggregate-functions date-arithmetic

Add Delay to a view that joins two tables...

sql sql-server where-clause date-arithmetic

How to find the duration of difference between two dates in java?...

java date-arithmetic