Hi , I have problem with datetime , dig around google try but wonder why I can not.
In database keep nvarchar(1) like '20111010' and I'd like the result as date with no time. I try as following...
SELECT convert(datetime,'20111010',103)
the result still
2011-10-10 00:00:00:000
Actually , I want 10/10/2011
Help me please..
Natchaya....
Loading
VulpesPosted Dec 22, 2011, 11:50 AM
Jignesh TrivediPosted Jan 5, 2012, 1:30 AM
also try following..
http://www.sql-server-helper.com/tips/date-formats.aspx
http://msdn.microsoft.com/en-us/library/ms187928.aspx
hope this help.
natchaya khamkunaPosted Dec 22, 2011, 10:47 PM
Natchaya