---
title: "Need output in dd/MM/yyyy format from table value pair"  
description: "Need output in dd/MM/yyyy format from table value pair"  
author: "Anonymous User"  
published: 2013-12-23  
updated: 2013-12-23  
canonical: https://www.mindstick.com/forum/1827/need-output-in-dd-mm-yyyy-format-from-table-value-pair  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# Need output in dd/MM/yyyy format from table value pair

Here is my code for passing [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) value pair to stored procedure. DOJ field is [DateTime](https://www.mindstick.com/forum/12949/how-to-validate-if-a-datetime-field-is-not-null-empty) and in SP, DOJ field is date. Both are compatible. [Output](https://www.mindstick.com/interview/34427/explain-the-output-in-angular) is like dd/MM/yyyy.

If DOJ field is DateTime and in SP, DOJ field is DateTime2(3), o/p is dd/MM/yyyy hh:mm:ss But I need o/p to be dd/MM/yyyy. How should i write the code ?

dt1.Columns.Add("DOJ", typeof(System.DateTime));

DataRow dr1 = dt1.NewRow();

dr1["DOJ"] = DateTime.ParseExact("02/03/2001", [formats](https://www.mindstick.com/forum/160705/explain-the-concept-of-datetime-formats-in-c-sharp), us, DateTimeStyles.None);

// dr1["DOJ1"] = "12/13/2001"; if i use this one it works .

dt1.Rows.Add(dr1); // Get DOJ as - 3/2/2001 12:00:00 AM

ds1.Tables.Add(dt1);

Here is my [stored procedure](https://www.mindstick.com/articles/803/using-stored-procedure-in-asp-dot-net) code -

-- CREATE TYPE StateTbls7 AS TABLE

( StateID [VARCHAR](https://www.mindstick.com/forum/161878/what-is-the-difference-between-nvarchar-and-varchar)(200)

, StateCode VARCHAR(200)

, StateName VARCHAR(200)

, DOJ date

)

ALTER PROCEDURE sp_Add_contact

(

@ds1 StateTbls7 [readonly](https://www.mindstick.com/forum/1419/how-can-i-make-the-wpf-datagrid-cells-readonly)

)

AS

begin

declare @DOJ VARCHAR(200)

[select](https://www.mindstick.com/forum/160534/orderby-then-select-vs-select-then-orderby-performance) @DOJ = d1.DOJ from @ds1 d1

select @DOJ as 'a1'

end

return

## Replies

### Reply by Pravesh Singh

Hi Ankita,\

Remove 'formats' declaration

Instead, change like this in your c#,

dr1["DOJ"] = DateTime.ParseExact("02/03/2001", us, DateTimeStyles.None).ToString("d");


---

Original Source: https://www.mindstick.com/forum/1827/need-output-in-dd-mm-yyyy-format-from-table-value-pair

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