以时间作为条件查询记录(案例)

CREATE TABLE [dbo].[Q_Order] ([Order_Date] DATETIME )

INSERT INTO [dbo].[Q_Order] ([Order_Date])
VALUES
(‘2019-04-16 09:45:00.097’),
(‘2019-04-19 12:05:23.092’),
(‘2019-04-25 05:05:04.000’),
(‘2019-05-03 20:25:00.492’),
(‘2019-05-07 21:09:45.106’),
(‘2019-05-09 17:55:00.083’),
(‘2019-05-10 03:27:00.000’),
(‘2019-05-11 14:20:44.113’),
(‘2019-05-16 09:33:16.106’),
(‘2019-05-18 23:15:39.997’),
(‘2019-05-20 12:06:46.765’),
(‘2019-05-20 15:31:26.881’),
(‘2019-05-20 22:40:22.094’),
(‘2019-05-26 09:43:47.392’),
(‘2019-06-01 01:34:41.654’),
(‘2019-06-02 08:07:06.003’)

–查询2019年5月份的记录：
SELECT* FROM [dbo].[Q_Order] WHERE YEAR([Order_Date]) = 2019 AND MONTH([Order_Date]) = 5

–查询某段时间之间的记录：
DECLARE @s_date DATE = ‘2019-05-08’,@e_date DATE = ‘2019-05-23’
SELECT * FROM [dbo].[Q_Order] WHERE [Order_Date] >= @s_date AND [Order_Date] < DATEADD(D,1,@e_date)

DECLARE @q_date DATE = ‘2019-05-20’
SELECT * FROM [dbo].[Q_Order] WHERE [Order_Date] >= @q_date AND [Order_Date] < DATEADD(D,1,@q_date)

获取系统当前年月日
Calendar cal = Calendar.getInstance();
int day = cal.get(Calendar.DATE);
int month = cal.get(Calendar.MONTH) + 1;
int year = cal.get(Calendar.YEAR);
int dow = cal.get(Calendar.DAY_OF_WEEK);
int dom = cal.get(Calendar.DAY_OF_MONTH);
int doy = cal.get(Calendar.DAY_OF_YEAR);

System.out.println("Current Date: " + cal.getTime());
System.out.println("Day: " + day);
System.out.println("Month: " + month);
System.out.println("Year: " + year);
System.out.println("Day of Week: " + dow);
System.out.println("Day of Month: " + dom);
System.out.println("Day of Year: " + doy);