date related issues & queries in DbaXchanger



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







SET DATESTYLE TO 'European'; in MySQL

mysql postgresql date
Updated September 23, 2018 20:06 PM













datetime row created

sql date time row
Updated July 11, 2018 06:06 AM

Showing Page 1 of 0