Remove Datetime By query to show inLabel or Textbox

Question

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.

Code Alone · Answer

Hi, There are mu ltiple conversion options av ailable 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

Tushar Dikshit · Answer

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.

Shweta68 · Answer

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.

Sanwar Ranwa · Answer

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)