Problem in datetime formatting

Rajesh Goswami 2826 12 Aug 2011

I want to convert datetime (which is value :08/08/2001 ) into 2001/08/08 .But i can not find any appropriate solution in sql server
give the solution of this problem
thanks in advance

1 Answers

Shankar M 10 Feb 2013

Hi Rajesh,

Hope this might help you,

SELECT CONVERT(VARCHAR(10),CONVERT(DATETIME,'21/02/1987',103),111)

Regards,

Shankar

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Problem in datetime formatting

Can you answer this question?

1 Answers