equivalent of PostgreSQL type "timestamp without time zone" in SQL Server

Question

what is the type equivalent of postgresql "timestamp without time zone" in SQL Server?

would it be ok to use DateTime?

score 13 · Answer 1 · edited May 23 '17 at 12:02

13

For new development you can use the datetime2 data type, not the "plain" datetime. It stores a timestamp with no time zone, and lets you specify the precision that you need for your system.

To get the precision of 1 microsecond, which is the equivalent of timestamp without time zone in PostgreSQL, you need to specify precision of 6 fractional digits, i.e.

datetime2(6)

See this answer for details on why Microsoft recommends using datetime2.

edited May 23 '17 at 12:02

Community

1
1

answered Feb 20 '14 at 16:24

Sergey Kalinichenko

714,442
84
1,110
1,523

thanks, but is this the type to use to translate from PostgreSQL type "timestamp without time zone"? – user441365 Feb 20 '14 at 17:15
@user441365 You need `datetime2(6)` to match PostgreSQL's precision. – Sergey Kalinichenko Feb 20 '14 at 17:28

equivalent of PostgreSQL type "timestamp without time zone" in SQL Server

1 Answers1