Print Page | Close Window

DATETIME2(0) and TIME(0)

Printed From: TMS Software
Category: Business Tools
Forum Name: Data Modeler
Forum Discription:
URL: http://www.tmssoftware.com/site/forum/forum_posts.asp?TID=2593
Printed Date: 10 Dec 2019 at 10:15am


Topic: DATETIME2(0) and TIME(0)
Posted By: Vitek Roman
Subject: DATETIME2(0) and TIME(0)
Date Posted: 15 May 2013 at 8:03am
Hi,
in MS SQL 2008 there are new types: DATETIME2(x) and TIME(x) where x is time precision (sec). I use x = 0, but DM (version 2.1.1.0) convert it to x=7 when I open my project. I use it in logical domains. When I define/edit logical domain: DT = DATETIME2(0) its OK. But after close and reopen DM there are: DT = DATETIME2(7).

Thanks Roman



Replies:
Posted By: Wagner R. Landgraf
Date Posted: 24 May 2013 at 1:43pm
Hi Roman, 

thanks for reporting. This issue should be fixed now, apply the newest updates. You might need to open and save project again to see the fixes/changes.


Posted By: VĂ­tek Roman
Date Posted: 10 Oct 2013 at 11:04am
Hi,

I have DM version 2.2.2.0 - Generate script produce "DATETIME2(0)" but Compare function produce "DATETIME2(7)". I have defined: DATETIME2(0). Check function still generate Warnings about precision 0: Size was not specified on field XY.

Thanks, Roman


Posted By: Wagner R. Landgraf
Date Posted: 10 Oct 2013 at 2:54pm
Fixed, new version is available through automatic update.



Print Page | Close Window