Answer

Please help for date query in SQL server?

Santhosh K S

12y

928

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)

Next Recommended Forum

How to create multiple index for the same table?

Sql insertion error

Leaderboard

View all

Harshit Pandey

Priyanshu Agnihotri

Shivam Payasi

View all

Yesterday's leader

Harshit Pandey

java, python, BigData

Kanpur (Holy See (Vatican City))

9.1k

121.2k

Member of the month

Rinki

Chennai (India)

5.5k

14.8k

Speaker of the month

Shivam Payasi

C#, .NET

Chitrakoot (India)

21.3k

19.3k

Upcoming events

View all

Suggested for you

View all

John Miller

James Tomar

Daisy Princess

Deepak Tewatia

Alistair Cook

Forum Statistics

Please welcome our newest member Grace Lee.
2,380,749 users have contributed to 122,527 threads and 388,993
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'How can I optimize my Twilio SMS usage to reduce costs?'.