sample1.sql

来自「T-SQL示例大全」· SQL 代码 · 共 33 行

/* 文件名称: Sample1.sql */

SET DATEFORMAT ydm

GO

DECLARE @datevar datetime
SET @datevar = '2001/21/09'
SELECT @datevar

GO

SET DATEFORMAT mdy

GO

DECLARE @datevar datetime
SET @datevar = '09/21/2001'
SELECT @datevar

GO

SET DATEFORMAT ymd

GO

DECLARE @datevar datetime
SET @datevar = '2001/09/21'
SELECT @datevar

GO