Remove Datetime By query to show inLabel or Textbox

Shweta68

Hello

I have a column RegDate(Datetime). When I select it by query then it gives me data like : 2018-08-23 23:42:48.300

I need to display the Date only. For this I write following code its working properly.

string RegDate = dt1.Rows[0]["RegDate"].ToString();
DateTime dRegDate = Convert.ToDateTime(RegDate);
lblRegDate.Text = dRegDate.ToString("dd MMM yyyy");

Can I solve it in one line or I can change it by query?

Kindly help me.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Code Alone8y ago
Accepted answer
Hi,

There are multiple conversion options available in MSSQL for Datetime conversion.
In your query try CONVERT(NVARCHAR(50),RegDate,106) AS RegDate; Execution result will be like "25 Aug 2018".

Here 106 is the code, which used for dd MMM yyyy conversions. There are various formats available in SQL from 100 to 114, 120 and so on. You can use them.

For more detailed about sql conversion visit below :
https://www.c-sharpcorner.com/blogs/how-to-format-datetime-date-in-sql-server-2005

Thanks
+3
Shweta688y ago
Thanks Tushar and Pradeep. Both answers helped me.

I got the desired result by CONVERT(NVARCHAR(50),RegDate,106) AS RegDate;
Pradeep your detailed conversion link will solve my further issues about datetime in sql.
+2
Sanwar Ranwa8y ago
Hello shweta

PleaseUse this format in your query

select convert(varchar(10), '2011-02-25 21:17:33.933', 120)

or

SELECT CAST (GETDATE() AS DATE)
-1
Tushar Dikshit8y ago
hi,
yes you can formatt date while selecting in query, example -
select CONVERT (varchar(10), getdate(), 103) AS CurrentDate
getdate() could be your column.
You can chaneg the formatt as,
select CONVERT (varchar(10), getdate(), 101) AS CurrentDate
Also to get dd-mmm-yyyy, try this.
Select CONVERT (varchar(20), getdate(), 106) AS CurrentDate
thanks.
+2