CREATE TABLE test_cc
(
id_orderid INT,
ih_timestamp DATETIME,
ih_name VARCHAR(20)
)INSERT INTO test_cc VALUES (1,'2013-04-11 09:12:22.000','park')
INSERT INTO test_cc VALUES (0,'2013-04-25 19:50:12.000','root')
INSERT INTO test_cc VALUES (1,'2013-04-29 12:13:02.000','jack')
INSERT INTO test_cc VALUES (0,'2013-07-01 11:05:00.000','peety')
INSERT INTO test_cc VALUES (1,'2013-07-24 23:29:44.000','kill')
INSERT INTO test_cc VALUES (0,'2013-07-13 20:14:43.000','sam')
INSERT INTO test_cc VALUES (1,'2013-11-11 08:20:26.000','stan')
INSERT INTO test_cc VALUES (0,'2013-11-23 14:15:09.000','orc')
INSERT INTO test_cc VALUES (1,'2013-11-30 16:59:59.000','emait')
要得到如下结果
(
id_orderid INT,
ih_timestamp DATETIME,
ih_name VARCHAR(20)
)INSERT INTO test_cc VALUES (1,'2013-04-11 09:12:22.000','park')
INSERT INTO test_cc VALUES (0,'2013-04-25 19:50:12.000','root')
INSERT INTO test_cc VALUES (1,'2013-04-29 12:13:02.000','jack')
INSERT INTO test_cc VALUES (0,'2013-07-01 11:05:00.000','peety')
INSERT INTO test_cc VALUES (1,'2013-07-24 23:29:44.000','kill')
INSERT INTO test_cc VALUES (0,'2013-07-13 20:14:43.000','sam')
INSERT INTO test_cc VALUES (1,'2013-11-11 08:20:26.000','stan')
INSERT INTO test_cc VALUES (0,'2013-11-23 14:15:09.000','orc')
INSERT INTO test_cc VALUES (1,'2013-11-30 16:59:59.000','emait')
要得到如下结果
解决方案 »
- 第2行缺少结束语句但是怎么都找不到!!!!!!!
- 通过restore headeronly from bak1语句,如何取得这个结果集中的某一条记录的BackupName, Position, DatabaseCreationDate的具体值?
- 高手请进,记录个数的查询问题
- 求SQL,查联程数据
- 求问TreeView 在SQL查询语句的使用
- 我创建了一个自定义类型,但要修改它的默认值,这么修改?
- 简单送分题目:在将excel 导入sql server 2000 中遇到的小问题
- 这个存储过程有什么错误
- 跨服务器建视图问题
- Access文件导入到SQL Server当中去如何编程
- SQL SERVER跨服务器连接能够用到索引吗?
- Sql 语句查询时间的年月
--(
-- id_orderid INT,
-- ih_timestamp DATETIME,
-- ih_name VARCHAR(20)
--)
--INSERT INTO test_cc VALUES (1,'2013-04-11 09:12:22.000','park')
--INSERT INTO test_cc VALUES (0,'2013-04-25 19:50:12.000','root')
--INSERT INTO test_cc VALUES (1,'2013-04-29 12:13:02.000','jack')
--INSERT INTO test_cc VALUES (0,'2013-07-01 11:05:00.000','peety')
--INSERT INTO test_cc VALUES (1,'2013-07-24 23:29:44.000','kill')
--INSERT INTO test_cc VALUES (0,'2013-07-13 20:14:43.000','sam')
--INSERT INTO test_cc VALUES (1,'2013-11-11 08:20:26.000','stan')
--INSERT INTO test_cc VALUES (0,'2013-11-23 14:15:09.000','orc')
--INSERT INTO test_cc VALUES (1,'2013-11-30 16:59:59.000','emait')SELECT DATEPART(year,ih_timestamp)[年份],DATEPART(MONTH,ih_timestamp) AS [月份],DATEPART(day,ih_timestamp) AS [日期] from test_cc
/*
年份 月份 日期
----------- ----------- -----------
2013 4 11
2013 4 25
2013 4 29
2013 7 1
2013 7 24
2013 7 13
2013 11 11
2013 11 23
2013 11 30
*/
select year(ih_timestamp) 年份,month(ih_timestamp) 月份,day(ih_timestamp) 日期 from
test_cc
select parsename(convert(varchar(10),ih_timestamp,102),3) 年份,parsename(convert(varchar(10),ih_timestamp,102),2) 月份,parsename(convert(varchar(10),ih_timestamp,102),1) 日期 from test_cc