natchaya khamkuna

natchaya khamkuna

  • NA
  • 31
  • 23.5k

How to handle datetime in query

Dec 22 2011 11:28 AM
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....





Answers (3)