Archive for the 'database' Category

12 Jan 2019

mysql date range creation

11:36 | database, mysql | 32 views

Goal: create a date range Simple question to create a date range from a start date to an end date. 1. date dimension table – previously created range Simple, let’s create a date dimension table filled up with the days from a specified day to the future(?). This is a very dangerous if we forget […]

17 Jul 2014

simple mdac test

11:59 | database | 288 views

Goal: to show a simple way to test a data provider The base problem is to check quickly the data provider we need. In this case this is an old odbc driver for a dbf database. Seemingly the simpliest way is this following: First of all we need an installed excel, because we will use […]

#sidebar a { color:#fff; } #sidebar ul ul li { color: #DEF585; } #sidebar h2 { color: #fff; } #sidebar ul p, #sidebar ul select { color: #BEDDBE; } #backfly { background: url(images/golfBallWallPaper.jpg) left bottom fixed repeat-x #65a51d; }