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

Editting a solarwind report

Hi,

How do edit the data and time format from MM/dd/yy to dd/mm/yy? I have tried changing but to no avail.

Find more posts tagged with

Accepted answers

All comments

I believe it's only possible if you have the raw query, then, you can use the function like so...

SELECT concat(day(timestamp),'/',month(timestamp),'/',year(timestamp)) as ConvertedTimestamp FROM [table]

or you could export it to csv and convert it within excel.

Quick Links