Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SQL for last 30 days - date calculation

Hi all,

I am creating a bespoke report based on the built-in Orion "last 30 days" report. In Report Writer the SQL is something like this:

SELECT .....
FROM .....
WHERE
( DateTime BETWEEN 87893 AND 87922 )

As the report is a 'rolling' 30 days, how does report writer calculate the 5-digit values above? When I look at the SQL in the writer app they have already been worked out...

Thanks ,

Stephen

Find more posts tagged with

Accepted answers

All comments

DonYonce

This is part of the undocumented magic of SQL. Orion converts these dates to numbers in order to easily support many different International date/time formats. You could just as easily use "( DateTime BETWEEN '10/1/2005' AND '10/5/2005' )" instead.

You could also use "( DateTime > (GetDate()-30) )" to select the past 30 days.