747b0392__5_1___Postgres_OnLine_Journal__Microsoft_SQL_Server_2008
[Feature] Date Time support [MySQL 5.1] Date and DateTime but none with Timezone, but you can have timezone, see Rob Wultsch comments. [PostgreSQL 8.4] (Seems pretty much on par with SQL Server) - Not much changed - Date, TimeStamp and TimeStamp with Timezone (not to be confused with MySQL's timestamp which autoupdates or SQL Server's deprecated timestamp which is a binary). Has Interval which neither MySQL nor MS SQL Server have. [Microsoft SQL Server 2008] 
Finally they support plain date - Date, DateTime,DateTimeOffset. (Date and DateTimeOffset are new)
Cross Compare of PostgreSQL 8.4, SQL Server 2008, MySQL 5.1 - Postgres OnLine Journal
Microsoft SQL Server 2008