Sql

Search

sql server datetime vs datetime2

The MSDN documentation for datetime recommends using datetime2. Here is their recommendation:

Use the time, date, datetime2 and datetimeoffset data types for new work. These types align with the SQL Standard. They are more portable. time, datetime2 and datetimeoffset provide more seconds precision. datetimeoffset provides time zone support for globally deployed applications.

datetime2 has larger date range, a larger default fractional precision, and optional user-specified precision. Also depending on the user-specified precision it may use less storage.

Comment

PREVIOUS	NEXT

Code Example
Sql :: xampp mysql command to import a large database
Sql :: between date in sql server
Sql :: sql limit to 5 results
Sql :: select indexes postgres
Sql :: mysql select inside sum
Sql :: primary key sql
Sql :: sql add calculated column
Sql :: wamp server mysql password
Sql :: create a table in sql
Sql :: sql create cluster index
Sql :: how to get information about data types in postgreSQL
Sql :: operator in sql
Sql :: peewee print sql
Sql :: azure check access to sql database
Sql :: oracle list chain steps
Sql :: mysql bind-address default value
Sql :: postgres insert into table
Sql :: remove decimal in sql server
Sql :: insufficient privileges while creating view in sql oracle
Sql :: Inserting data into different tables at once in oracle sql
Sql :: create user with encrypted password postgresql
Sql :: how to avoid duplicate records in sqlite
Sql :: sql server get date of previous sunday
Sql :: import sql file to mysql db using shell commands
Sql :: sql group_concat
Sql :: how to increase the width of the screen in oracle
Sql :: pl sql command line run
Sql :: sql is null and is not null
Sql :: join three tables sql
Sql :: set up mssql in mac m1

Search

SQL

sql server datetime vs datetime2

ADD CONTENT