"INSERT INTO" Shortcut returns wrong time in datetime field

shooper

I have a table with a datetime field.

Using SqlPrompt 4, when I type INSERT INTO, SqlPrompt creates the insert statement, but the value filled into the datetime field is wrong. The date is correct, but the time is 4 hours in the future.

This worked correctly in 3.9.

TABLE CREATE STATEMENT:

CREATE TABLE [dbo].[CS_DIR_EXCEPTION]
(
[FederalSiteIdentifier] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[CS_Error_ID] [smallint] NOT NULL,
[ExemptedOn] [datetime] NOT NULL,
[RDIMS] [int] NOT NULL
) ON [PRIMARY]
GO


INSERT INTO CODE (at 13h31):

INSERT INTO dbo.CS_DIR_EXCEPTION
( FederalSiteIdentifier ,
CS_Error_ID ,
ExemptedOn ,
RDIMS
)
VALUES
( '' , -- FederalSiteIdentifier - char(8)
0 , -- CS_Error_ID - smallint
'2009-10-02 17:31:27' , -- ExemptedOn - datetime
0 -- RDIMS - int
)

Chris.Allen

Thanks for bringing this to our attention. Its a good old-fashioned bug. I have assigned it this reference:

SP-2833

I cannot makle any promises about fix tiemscales but we will try to get a private fix out for this if we can (and let you know through this post).

shooper

Thanks Chris.