What are the challenges you face when working across database platforms? Take the survey
Options

"INSERT INTO" Shortcut returns wrong time in datetime field

shoopershooper Posts: 3
edited October 6, 2009 9:58AM in SQL Prompt Previous Versions
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
)

Comments

Sign In or Register to comment.