sample54.sql

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

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

SET DATEFORMAT mdy
DECLARE @vlDateTime datetime
SET @vlDateTime = '09/26/2002 09:20:45:556 PM'

SELECT CONVERT(varchar(30),@vlDateTime,100)
SELECT CONVERT(varchar(30),@vlDateTime,101)
SELECT CONVERT(varchar(30),@vlDateTime,1)
SELECT CONVERT(varchar(30),@vlDateTime,102)
SELECT CONVERT(varchar(30),@vlDateTime,108)
SELECT CONVERT(varchar(30),@vlDateTime,109)
SELECT CONVERT(varchar(30),@vlDateTime,121)