我正在使用2008年的服务器。
我有:
select convert(varchar(20),fmdate) from Sery
我如何将日期改为显示其为MM/DD/YYYYY。
这项任务应该由您的软件包的下层完成。 它是一个数据存放处,而不是一个列报系统。
You can do it with
CONVERT(VARCHAR(10), fmdate(), 101)
但是,你们应该这样做。
select convert(varchar(10), fmdate, 101) from sery
101 是一个风格的论点。
这里可以找到休息。
<>m>As of服务器 2012+<>em>, 您可使用FORMAT(<>><>>>>>
<<>Example>>:
SELECT FORMAT(GETDATE(), MM/dd/yyyy )
<<>Further Reading
select convert(varchar(10), cast(fmdate as date), 101) from sery
如果我没有投票,我就没有改写,那么时间就是说。
Just curious whether it s possible to mirror databases across versions.
SQL Server 2008 R2 has supposedly been Released to Manufacturing. Does anyone know when it s supposed to show up on MSDN?
Today was released SQL Server 2008 R2. Was trying to find what is new (from the developer perspective), but the MS sites has all the PR blah, blah, blah. There is something new to be aware?
I have a report that has ~1k columns and ~17k rows and I m trying to render it to Excel 2007 with SSRS 2008 R2 Nov CTP. SSRS team members have mentioned in multiple places that Excel 2007 format is ...
I am trying to use Data-Tier applications and am going through the tutorial here. When I get to step two the tutorial says to open Utility Explorer in the view menu. But it is not there! I looked all ...
What does PI in OSIsoft s PI System stand for? I can t tell if it stands for the symbol/number Pi, or if it stands for a previous name for the technology, like Process Intelligence . PI is too ...
We have a few huge databases (20GB+) which mostly contain static lookup data. Because our application executes joins against tables in these databases, they have to be part of each developers local ...
Using a SQL 2008 R2 November release database and a .net 4.0 Beta 2 Azure worker role application. The worker role collects data and inserts it into a single SQL table with one identity column. ...