date related issues & queries in DbaXchanger







DATE_SUB with configurable value

mysql-5.7 aws date-math
Updated April 26, 2019 19:06 PM


Why does year 0 become year 2000?

postgresql date
Updated April 19, 2019 22:06 PM

Update data not run

update date
Updated April 16, 2019 14:06 PM




Getting midnight of today

mysql date
Updated March 28, 2019 10:06 AM



find the latest date before target date

date case
Updated March 07, 2019 09:06 AM

CONVERT DATE TO STRING

postgresql-9.4 timestamp date convert
Updated March 07, 2019 08:06 AM


SQL date question

date-format
Updated February 25, 2019 18:06 PM


Splitting a year into pieces

sql-server sql-server-2008 date
Updated February 14, 2019 13:06 PM

Get closest previous date

mysql datetime date
Updated February 08, 2019 14:06 PM








Creating a database for due dates

table date
Updated December 23, 2018 06:06 AM


Converting and Subtracting Two Dates

t-sql date
Updated December 13, 2018 23:06 PM

Sum values by time

mysql date time
Updated December 13, 2018 22:06 PM



Generate Dates between Date Ranges in mysql

mysql cte date
Updated December 05, 2018 10:06 AM

Select data from the previous 3 months

sql-server t-sql date
Updated November 27, 2018 15:06 PM

MySQL - Classic Date Functions

mysql date
Updated November 21, 2018 19:06 PM



Fiscal Year dynamic function (Oracle SQL)

oracle query date
Updated November 15, 2018 15:06 PM

Fiscal Year to Date filter

oracle optimization date
Updated November 14, 2018 16:06 PM



Showing Page 1 of 0