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

Unable to use DATEPART in SWQL studio

To fetch the date below query is working

DATETRUNC('day', [N].Timestamp)

To fetch the Hour in the time i try DATEPART('HOUR',[N].Timestamp) but DATEPART is not working. Anyone please help. I need to show Hour details in one column.

Find more posts tagged with

SWQL

Accepted answers

All comments

christopher.t.jones123

@rajasekar, you should just be able to cchangethe 'day' to 'hour' to achieve what you are looking for. See the below link for supported SWQL functions and usage information.

github.com/.../SWQL-Functions

StillGoing

As Christopher mentioned SWQL Functions · solarwinds/OrionSDK Wiki · GitHub is the definitive source of what functions are and are not supported in SWQL.

And, as you have discovered, DATEPART is NOT a supported function for SWQL. But, if I understand your example correctly, I believe you should be able to achieve what you want using the HOUR function; e.g.

HOUR( [N].Timestamp )

Hope that helps!