Time format yyyy-MM-dd HH:mm:ss does not work correctly

In the table customizer, when I use this ‘yyyy-MM-dd HH:mm:ss’ to format a time stamp, I am getting ‘yyyy-MM-dd HH:mm:ss.sss’

What is the table bound to? SQLTags history?

In one case it’s a sql query on a postgres table. In an other is data returned from system.alert.queryAlertHistory.

The date format string only happens when the column in the dataset is a DATETIME data type. The queryAlertHistory right now does not return it as such. Check your dataset to see what the data type is.

I looked at the dataset and it showed ‘07/01/2010 12:08:52’. The table displaying the dataset showed 2010-07-01 12:08:53.471. In the table customizer the format is ‘yyyy-MM-dd HH:mm:ss’

You need to look at the actual type of the column in question. You can see this in the dataset viewer for that property.

Finally got this setup again.

The dataset viewer says the column is a date column.
Why would the formatting work in the viewer but not the actual table?

Can you export the window and send it to us or post it here please?

alarmsummary.vwin has been uploaded to the support area.

I must be missing something. Looks correct to me.


I’m running 7.1.4
alarmsummary.pdf (209 KB)

Maybe it has to do with running in a French locale? We’ll investigate