How to change the date time 2021-05-02T11:07:34Z to "DD/MM/YYYY HH:MM:SS" while using sql server date time data

Grafana
1

I want to show SQL server date time data in the “DD/MM/YYYY HH:MM:SS” but im getting data like this 2021-05-02T11:07:34Z. how to format it. my sql server code is -

/****** Script for SelectTopNRows command from SSMS ******/
SELECT [Id]
,[DeviceImei] as ‘IMEI’
,[DeviceTimeStamp] as ‘Date & Time’
,[MachineName] as ‘Machine Name’
FROM Transformer
order by id desc
Screenshot_215

2

This topic was automatically closed after 365 days. New replies are no longer allowed.