1

Closed

Datetime becoming truncated

description

Before scripting dates looked like this:
13/05/2011 11:35:06.797
 
afterwards they became:
13/05/2011 00:00:00.000
 
As a workaround/solution I changed line 12 in the file SQLServerSyntax.cs :
 
? string.Format("'{0}-{1:00}-{2:00}'", value.Value.Year, value.Value.Month, value.Value.Day)
 
new:
 
? string.Format("'{0}-{1:00}-{2:00} {3:00}:{4:00}:{5:00}.{6:000}'",
value.Value.Year, value.Value.Month, value.Value.Day, value.Value.Hour, value.Value.Minute, value.Value.Second, value.Value.Millisecond)
Closed May 20, 2011 at 8:28 PM by General1

comments

wrote May 20, 2011 at 8:28 PM

Resolved with changeset 4819.

wrote Feb 2, 2013 at 2:38 AM

wrote May 14, 2013 at 10:23 PM