This code don't work, becuse it converts standart input into unstandart output. I need the oposite of it.
UPDATE DoslaObjednavka SET DatumPozadovany = CONVERT(datetime, @.DatumPozadovany, 13), Oznaceni = @.Oznaceni WHERE (Id = @.Id)
Please, help.
SELECT CONVERT(DATETIME, GETDATE(),109)
--returns 2007-02-12 21:09:56.970
SELECT CONVERT(nvarchar(26), GETDATE(),109)
--returns Feb 12 2007 9:09:56:970PM
From the SQL Server 2005 Books Online topic
CAST and CONVERT (Transact-SQL)
"In the following table, the two columns on the left represent the style values for converting datetime or smalldatetime data to character data. Add 100 to a style value to obtain a four-place year that includes the century (yyyy).
Rob|||Thaks everyone for reply. Error was at very different place.
In ASP.NET i didn't specify parametr datatype. It expected some strange datetime format and didn't work. Now it works fine.
No comments:
Post a Comment