select convert(smalldatetime,'14/05/2012 20:20:00',103)
output is 2012-05-14 20:20:00
But
i need date in terms of 15/04/2012 20:20:00 please suggest........
thanks in advance
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Anil KumarPosted May 18, 2012, 2:05 AM
For different formats, you may refer http://www.sql-server-helper.com/tips/date-formats.aspx