How to handle datetime in query

Question

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....

Vulpes · Answer

I'd try: SELECT convert(varchar(10) convert(datetime '20111010' 112) 103)

Jignesh Trivedi · Answer

Hi 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 khamkuna · Answer

Thank you so much . It's working. I appreciated.. Natchaya