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:
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;
CREATE FUNCTION [dbo].[f_get_first_date_of_month]
(
@Date DATETIME
)
RETURNS DATETIME
AS
BEGIN
return DATEADD(d, 0, DATEADD(m, DATEDIFF(m, 0, @Date), 0))
END
CREATE FUNCTION [dbo].[f_get_last_date_of_month]
(
@Date DATETIME
)
RETURNS DATETIME
AS
BEGIN
RETURN DATEADD(d, -1, DATEADD(m, DATEDIFF(m, 0, @Date) + 1, 0))
END