Displaying values in milliseconds in a Section Report.

Question:

How can I display values in milliseconds in a Section Report of Elipse E3?

Solution:

To display date/time values in milliseconds, you’ll need to edit the format at SQL syntax Section Report‘s.

Example (SQL Server):

SELECT Format([E3TimeStamp] , 'yyyy-MM-dd HH:mm:ss.fff') as DataHoraMS, Campo1, Campo2
FROM [Tabela1] 
ORDER BY DataHoraMS ASC

Example (PostgreSQL):

SELECT to_char(pgsql.E3TimeStamp, 'DD-MM-YYYY HH24:MI:SS.MS'), pgsql.Campo1 
FROM pgsql 
ORDER BY pgsql.E3TimeStamp ASC