當試圖在兩者之間獲得相同的日期時，它只是扔了一張空桌子。我的表結構如下：
CREATE TABLE [dbo].[tblNames](
[RorId] [int] IDENTITY(1,1) NOT NULL,
[Name1] [varchar](1) NOT NULL,
[Name2] [nvarchar](1) NOT NULL,
[BirthDate] [datetime] NULL,
CONSTRAINT [PK_tblames] PRIMARY KEY CLUSTERED
(
[RorId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
和一些資料：
SET IDENTITY_INSERT [dbo].[tblNames] ON
GO
INSERT [dbo].[tblNames] ([RorId], [Name1], [Name2], [BirthDate]) VALUES (1, N'A', N'A', CAST(N'2022-06-13T10:52:00.000' AS DateTime))
GO
INSERT [dbo].[tblNames] ([RorId], [Name1], [Name2], [BirthDate]) VALUES (2, N'C', N'E', CAST(N'2022-06-13T11:52:00.000' AS DateTime))
GO
INSERT [dbo].[tblNames] ([RorId], [Name1], [Name2], [BirthDate]) VALUES (3, N'C', N'E', CAST(N'2022-06-13T12:52:00.000' AS DateTime))
GO
INSERT [dbo].[tblNames] ([RorId], [Name1], [Name2], [BirthDate]) VALUES (4, N'E', N'C', CAST(N'2022-06-13T08:52:00.000' AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[tblNames] OFF
GO
uj5u.com熱心網友回復：
試試這個：
select * from tblNames
where BirthDate >= '2022-06-13 00:00:00' and BirthDate <= '2022-06-13 23:59:59'
或者
select * from tblNames
where BirthDate between '2022-06-13 00:00:00' and '2022-06-13 23:59:59'
注意資料型別中Time的部分。datetime
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/493661.html