[LPS-84513] Increase precision of type datetime for SQL Server - Liferay Issues

XML

Word

Printable

Details

Type: Story
Status: Closed
Priority: Critical
Resolution: Completed
Affects Version/s: Master
Fix Version/s: 7.2.X, Master
Component/s: Environments > Databases
Labels:
- ee-ts

Branch Version/s:

7.2.x
Backported to Branch:

Committed
Git Pull Request:
https://github.com/brianchandotcom/liferay-portal-ee/pull/21624,https://github.com/brianchandotcom/liferay-portal/pull/62935

Description

In SQL Server the type DATETIME has smaller precision that a millisecond. In particular, time values will be rounded to one of the following values: .xx0 s, .xx3 s, or .xx7 s.

Starting with version 2008, the new type DATETIME2 was introduced which can allow up to a precision of 100 ns. The precision can be customized using the type DATETIME2(p), where p can range from 0 to 7, with a default value of 7.

Using DATETIME can lead to problems when comparing dates. See ~~LPS-84506~~ for an example.

Attachments

Issue Links

fixes

LPS-84506 Cannot always delete the last comment to a web content

Closed

Options

Sub-Tasks

1.	Upgrade dates to datetime2 in SQLServer - collaboration suite	LPS-84870	Closed	Brian Chan
2.	Upgrade dates to datetime2 in SQLServer (web experience suite)	LPS-86288	Closed	SE Support
3.	Upgrade dates to datetime2 in SQLServer (foundation suite)	LPS-86289	Closed	Brian Chan
4.	Upgrade dates to datetime2 in SQLServer (forms-and-workflow suite)	LPS-86291	Closed	Brian Chan

Activity

People

Assignee:: Koor Gai

Reporter:: Ricardo Couso

Recent user:: Kiyoshi Lee

Participants of an Issue:: Koor Gai, Ricardo Couso

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 16/Aug/18 2:45 AM

Updated:: 21/Oct/19 4:07 PM

Resolved:: 28/Mar/19 8:50 AM

Packages

Version	Package
7.2.X
Master