我使用数据库写一个查询,我想格式化日期我该怎么办 [英] i write a query using pivot in that i want to format the date how can i do
问题描述
我的查询如下;
select * FROM Tb_SCh_TIme_Table P PIVOT
(MAX(Faculty_Code)FOR Session IN([1],[2],[3],[4]))AS PVT课程顺序。
$ b当我在sql中运行输出时,$ b
;
日期课程session1 session2 session3 session4
2013-01-15 00:00:00.000 Aff CK Vb RC SJ
i希望sql输出中的日期格式如下;
日期课程session1 session2 session3 session4
15-jan-2013 Aff CK Vb RC SJ
我该怎么做。我的上述查询需要进行哪些修改,我该怎么做。
my query as follows;
select * FROM Tb_SCh_TIme_Table P PIVOT
(MAX(Faculty_Code) FOR Session IN ([1],[2],[3] ,[4])) AS PVT order by course.
when i run output as follows in sql;
Date course session1 session2 session3 session4
2013-01-15 00:00:00.000 Aff CK Vb RC SJ
i want the date format as follows in sql ouput;
Date course session1 session2 session3 session4
15-jan-2013 Aff CK Vb RC SJ
how can i do.what modification is needed in my above query,how can i do.
推荐答案
参见< a href =http://www.epsilon-logic.net/ELSQBHelpDocs/ConvToCharFunctions.htm>这里 [ ^ ]
这篇关于我使用数据库写一个查询,我想格式化日期我该怎么办的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!