ERROR: invalid input syntax for type timestamp: "Jan 21 2013 09:39:36:523AM" I have 2 questions: I cannot select from any table that has a column defined as a datetime in SQL and timestamp in postgres ...

CURRENT_TIMESTAMP (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw] This function returns the current database system timestamp as a datetime value, without the database time zone ...

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.