Download SQL Server Northwind Database .BAK File

Download the SQL Server Northwind Database backup from from Codeplex or by clicking the link below.

Download NORTHWIND.Bak.Zip

Easily Change the Style of DevExpress Grids to Match Bootstrap

All of the sites I build now use Bootstrap and DevExpress Grids. 

I wanted to style the DevExpress Grid to look more like Bootstrap. This method is not 100% but close enough for the purposes of the grids I have been using.

Add the following style and Javascript to any page / control that has a DevExpress Grid.


Here is a Before / After View of a grid
BEFORE:

AFTER:

How To Subtract Minutes and Days From an Oracle Timestamp

The following SQL will subtract 15 minutes from an Oracle Timestamp, and 20 hours from a timestamp.

--15 Minutes Ago
select systimestamp, 
          cast(to_char(sysdate - (15/(24*60)),'dd-mon-yyyy hh:mi:ss') as timestamp) 
from dual;

--Yesterday 20 hours ago
select systimestamp, 
          cast(to_char(sysdate - (1200/(24*60)),'dd-mon-yyyy hh:mi:ss') as timestamp) 
from dual;