---
title: "Problem in datetime formatting"  
description: "Problem in datetime formatting"  
author: "Rajesh Goswami"  
published: 2011-08-12  
updated: 2013-02-10  
canonical: https://www.mindstick.com/forum/286/problem-in-datetime-formatting  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Problem in datetime formatting

I want to [convert](https://www.mindstick.com/forum/2093/configurationmanager-appsettings-convert-n-to-n-why) [datetime](https://www.mindstick.com/forum/12949/how-to-validate-if-a-datetime-field-is-not-null-empty) (which is [value](https://www.mindstick.com/articles/23219/an-optimized-description-adds-value-to-experience-and-in-turn-effectively-guest-posting-packages) :08/08/2001 ) into 2001/08/08 .But i can not find any appropriate solution in [sql server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server)\
give the solution of this [problem](https://yourviews.mindstick.com/view/81399/tackling-the-problem-of-unemployment-during-corona-pandemic)\
\
thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)

## Replies

### Reply by Shankar M

Hi Rajesh,\
Hope this might help you,\
SELECT CONVERT(VARCHAR(10),CONVERT(DATETIME,'21/02/1987',103),111)\
Regards,Shankar


---

Original Source: https://www.mindstick.com/forum/286/problem-in-datetime-formatting

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.