Please help for date query in SQL server?

May 18 2012 1:47 AM

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

Answers (1)

How to create multiple index for the same table?

Sql insertion error