Support converting epoch time to datetime

[potchin]

I have a metric which stores a datetime in epoch format. I would like to show this as a human-readable string in singlestat

[galindro]

+1

[skebo]

+1

[wanderingnewfie]

+1

[koallen]

+1

[nagimov]

+1

[nindza]

+1

[rodrigocastrillon]

+1

[fretty]

+1

[aknapp112]

+1

[mikeyfreshh]

+1

[edwardslabs]

+1

[schbrongx]

+1

[liyuankui]

I think it's solved, just multiply it by 1000, and choose the type as Date

[kilteer]

Thanks @liyuankui. That's a quick & easy solution.

[ipsecguy]

Do we have a type Date?

[rohitnagpal88]

I am looking to do the exact same thing , display an epoch timestamp in human readable date in a singlestat. Can't seem to find the type Date . Is it there in any specific version ? Any help appreciated.

[rohitnagpal88]

I ended up using the prometheus query language itself to get the time in seconds and selected the stat as a duration in seconds (time() - singlestatquery)

[ipsecguy]

would you mind sharing the promQL snippet?

[rohitnagpal88]

time()-(process_start_time_seconds)

time() function in prometheus is used to get the current time in epoch. So you can use it to calculate the no. of seconds since the process last started. Choose the singlestat unit as time duration in seconds .

[torkelo]

implemented in #6297

add 3 new unit formats for dates

[karlsoon]

Hi!
How to use this?
I have this timestamp from metric: 1540655070

[rafawhs]

@karlsoon use scale function to multiply it by 1000

[caiges]

... and how might you do this for table data?

[ResolveWang]

@rafawhs Hi,rafawhs, what's the data source? I use prometheus and i can't find the scale function ?

[rafawhs]

@ResolveWang Graphite!

[Rekhs123]

I am also not able to view scale function. im using prometheus as data source. Please help

[enzobes]

@ResolveWang @Rekhs123
If you use Prometheus, Grafana wants metrics in Milliseconds.
For example : process_start_time_seconds * 1000
Then you can put your metrics in Date Format.

[cvernooy23]

anyway to convert epoch to human datetime in a table graph with a postgresql datasource?

[marefr]

@cvernooy23 use the column style date and select date format

[mjtrangoni]

@marefr How do you convert epoch to milliseconds inside a Prometheus Table? This is why I can`t use the date format.

[marefr]

@mjtrangoni see comment above. If not applicable please share your query you're using.

[mjtrangoni]

@marefr Yes, sorry, I was wrong and thought it was a column from a metric label, but it turn out this is indeed the value.
JIC, what if it would have been a label and not the value itself?

[marefr]

@mjtrangoni Given you have a label with epoch timestamp in millisecond format I think it should work to use column style date. If you need to do conversion your limited to solve that using prometheus query api. For the singlestat panel the support is broader, see demo.

[vivekj11]

Hi, I want to show uptime of my container on grafana, for that I have used something like
(( container_start_time*1000 )) and it is working absolutely fine. My problem is, as soon as this container is down, grafana is showing 63 years/122 years for this metrics.
I am using prometheus, cadvisor and grafana.
Any Help..!!

[CH-MN]

Putting Date and Time on a dashboard seems pretty fundamental. How do I do that? I used a singlestat to get Time of last point, of some arbitrary metric, which returns it in some non human readable format. I select YYYY-MM-DD HH:mm:ss for Unit, which converts it to just time. I assume it is because it is so recent? Why would Grafana make that kind of decision. If I wanted just time, there should be a HH:mm:ss selection! This thread goes back and forth I never see a definitive answer yet it is closed.

Using 6.4.1.

[harvey945]

Hi .i solved this problem.

HUAWEI-ENTITY-EXTENT-MIB::hwEntityManufacturedDate.67108873 = STRING: 2018-11-19,0:0:0.0

HELP hwEntityManufacturedDate This object indicates the manufacturing date of an entity.

The verification obtained by snmp is not accurate, let's correct it.

[root@TDengine generator]# date -d@1542585600 +"%Y-%m-%d %H:%M:%S"
2018-11-19 08:00:00
CST + 8:00:00 (28800s)
max((hwEntityManufacturedDate{instance="x.x.x.x"}) - 28800 ) * 1000

Thanks.