date-arithmetic Examples and Free Source Code

mysql with date function query running slow...

mysql sql query-optimization where-clause date-arithmetic

Generating counts of open tickets over time, given opened and closed dates...

sql postgresql count left-join date-arithmetic

How to query all data with current date when column is datetime in sqlite?...

sqlite date datetime where-clause date-arithmetic

SQL to get next monday in Presto...

sql datetime presto amazon-athena date-arithmetic

How to find the difference between two timestamped rows whenever value changes between rows in MySQL...

mysql sql gaps-and-islands date-arithmetic

The sum of Opening and Closing Balances for each Financial Year Grouped by Category in MYSQL...

mysql sql pivot aggregate-functions date-arithmetic

How I can substract one timestamp from another in Oracle...

sql oracle date-arithmetic

How to split the time range into multiple rows...

sql sql-server common-table-expression recursive-query date-arithmetic

How to insert a Calender Items into Oracle DB records?...

sql oracle sql-insert recursive-query date-arithmetic

Filtering data for the last 3 months using DATEADD() in SQL...

sql postgresql date-arithmetic

How can I convert a week (200851) into a date (2008-12-27)?...

sql sql-server t-sql date-arithmetic

How to fetch rows between two Unix timestamps...

javascript sqlite datetime where-clause date-arithmetic

How do I get a file's age in days in Ruby?...

ruby file-io date-arithmetic

PostgreSQL age() function: different/unexpected results when landing in dfferent month...

sql postgresql date-arithmetic

Get all days in a month excluding weekends postgresql...

sql postgresql datetime recursive-query date-arithmetic

How can i get number of quarters between two dates in PostgreSQL?...

sql postgresql date-arithmetic

oracle sql get last Sunday and last Saturday...

sql oracle date-arithmetic

Delete rows with date older than 30 days with SQL Server query...

sql-server date-arithmetic

Find the number of week rows in a month...

math date-arithmetic

BigQuery comparing DATE and TIMESTAMP...

sql google-bigquery aggregate-functions date-arithmetic sql-null

Convert time to duration...

sql postgresql datetime intervals date-arithmetic

How to convert Hours to Numeric in PostgreSQL...

sql postgresql date time date-arithmetic

Postgres converting double double precision to text creates '1.50000000000'...

sql postgresql date datetime date-arithmetic

Convert value in timediff() into string for mysql...

mysql sql string datetime date-arithmetic

MySQL: Update multiple rows with random values...

python mysql random sql-update date-arithmetic

How to sum time format (hh:mm:ss.ms) in mysql...

mysql sql datetime sum date-arithmetic

Reformat Varchar(6) into Time format...

sql sql-server string datetime date-arithmetic

Use filter criteria from one table to dynamically select data from another table an union all result...

sqlite date join foreach date-arithmetic

How to unnest the table based on date interval in Presto?...

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

Fill missing dates in PostgreSQL with zero...

sql postgresql left-join gaps-and-islands date-arithmetic