Update:
i am still getting this (4/14/2012 2:44:01 PM) result after trying this
select convert(varchar(30), 4/14/2012 2:44:01 PM ,121)
End Update
为了取得这一结果,应当采用何种格式:
2012-04-14 14:44:01.683
i 采用这一方法,但并未显示微米/百万分之二
select convert(varchar(23), 4/14/2012 2:44:01 PM ,120)
我得出这一结果:
4/14/2012 2:44:01 PM
http://msdn.microsoft.com/en-us/library/ms187928.aspx” rel=“nofollow”>CAST和CONVERT onDN Books Online, 您无法用一行回答。
SELECT CONVERT(VARCHAR(30), GETDATE(), 121)
这给我带来了以下产出:
2012-04-14 21:44:03.793
<>Update: based on You updated question - 当然,这赢得了t work - Yous reforming a string (The: 4/14/20122:44:01 PM
页: 1
引证:
SELECT CONVERT(VARCHAR(30), CAST( 4/14/2012 2:44:01 PM AS DATETIME), 121)
现在你们应当:
2012-04-14 14:44:01.000
显然,由于你最初的数值没有包含任何......,因此这些微秒的数值都是零。
更改日期:
select convert(varchar(23), convert(datetime, 4/14/2012 2:44:01 PM ),120)
select convert(varchar(30), CAST( 4/14/2012 2:44:01 PM As DATETIME),121)
I need to declare 12 decimal variables, corresponding to each month s year, with a cursor I sum values to this variables, then later I Update some sales information. I don t know if sql server has ...
Does anyone have experience with using indexed view in MS SQL Server 2008? I am trying to find out how does indexed view affect performance of insert / update statements, that are adding / updating ...
In Microsoft SQL Server Management Studio 2008, is there a secret to be able to edit one row based on a key? There s an option to do "Edit Top 200 Rows", but what if I want to select some other row ...
Has anyone any experience moving a number of identical SQL Server databases (with unique data) from individual local servers to a single internet based server? We currently have 10 companies using ...
While altering a table (removing a column) in SQL Server 2008, I clicked the Generate Change Script button and I noticed that the change script it generated drops the column, says "go" and then runs ...
I have a Money column in my SQL Server 2008 table. In my below query how can I round it to nearest 5$ select FineAmount from tickets Thanks
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
I am starting a project to create an "object versioning" feature for our software (.NET 3.5 / SQL Server 2008), basically it needs to do this: a user is looking at a customer: last name is "Smith-...