[EMPIREDB-378] PostgeSQL: SQL Pattern for TIMESTAMP Columns

• Type: Improvement
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: empire-db-2.5.1
• Fix Version/s: empire-db-3.0.0
• Component/s: Core
• Assignee: Jan Glaubitz
• Reporter: Jan Glaubitz
• Created: 28/Feb/22 11:21
• Updated: 28/Feb/22 12:11
• Resolved: 28/Feb/22 12:11

Description

in PostgreSQL there is just a data type TIMESTAMP but no data type "Date with time": https://www.postgresql.org/docs/9.5/datatype-datetime.html

In Empire-db 2 the SQL_DATETIME_PATTERN and SQL_TIMESTAMP_PATTERN just had seconds. They should have microseconds, too.