DateTime equivalent of Sql Server 2008 in PostgreSQL 9.2
postgresql, postgresql-9.2, sql-server-2008-r2
Solution
Datetime in MS SQL server has no timezone so that would match timestamp in postgresql. I don't expect it matters but postgresql has "only" microsecond precision while MS SQL has 100 nanosecond precision.
Problem
Should i be using timestamp or timestamp with time zone in PostgreSql 9.2? Which one matches the datetime version of Sql Server 2008.