java - 字符串或二进制数据将在时间输入到数据库时被截断

Question

如何获取当前时间并将其输入到 SQL 服务器中。有我的 table :

CREATE TABLE [dbo].[Audit](
    [PK_Audit] [int] IDENTITY(1,1) NOT NULL,
    [SequenceNumber] [int] NOT NULL,
    [TableName] [varchar](50) NOT NULL,
    [RunDate] [datetime] NOT NULL,
    [StartTime] [datetime] NOT NULL,
    [EndTime] [datetime] NOT NULL,
    [Description] [varchar](max) NULL,
    [Status] [varchar](50) NOT NULL,
    [ProcessName] [nchar](10) NOT NULL,
    [InsertCount] [int] NOT NULL,
    [UpdateCount] [int] NULL,
    [DeleteCount] [int] NULL,
 CONSTRAINT [PK_Audit] PRIMARY KEY CLUSTERED 
(
    [PK_Audit] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

我正在尝试使用 calander 获取时间并将其输入到数据库中:

Calendar cal = Calendar.getInstance();
java.util.Date start = cal.getTime();

对我来说，您似乎需要将其转换为 SQL 可以理解的内容，因此我执行了以下操作:

audit.setDate(4, new java.sql.Date(start.getTime()));

当我执行查询时，出现以下错误:

com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

我做错了什么？

Answer 1

您可以使用 SQL Server getdate() 功能:

update Audit set StartTime=getdate(), . . . where . . .

或

insert into Audit (StartTime, . . .) values (getdate(), . . .)