从SQL Server datetime条件查询

SELECT OrderID, CustomerID, OrderDate
FROM Orders
WHERE OrderDate > '2023-01-01';

-- 存储为UTC时间
UPDATE Orders SET OrderDate = GETUTCDATE();

-- 查询特定时区的订单
SELECT OrderID, CustomerID, OrderDate AT TIME ZONE 'Eastern Standard Time' AS LocalOrderDate
FROM Orders
WHERE OrderDate > '2023-01-01';

-- 创建索引
CREATE INDEX idx_OrderDate ON Orders(OrderDate);

-- 使用分区表（示例）
CREATE PARTITION FUNCTION pf_OrderDate (datetime)
AS RANGE RIGHT FOR VALUES ('2023-01-01', '2024-01-01');

CREATE PARTITION SCHEME ps_OrderDate
AS PARTITION pf_OrderDate
ALL TO ([PRIMARY]);

CREATE TABLE Orders (
    OrderID INT IDENTITY(1,1) PRIMARY KEY,
    CustomerID INT,
    OrderDate DATETIME NOT NULL
) ON ps_OrderDate(OrderDate);