Date output format

sathish

Hi,

I retrieves the date field as '2022-11-11T00:00:00+05:30', when fetches from Sql table, but need only date as '2022-11-11'

Can you plz suggest how to get the same using the format with C# code or sql.

Thanks

Sathish

4 Replies

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

Vishal Joshi3y ago

Accepted answer

Hello Sathish,

You can try the below way to get only Date from the DateTime.

string sqlDate = "2022-11-11T00:00:00+05:30";
DateTime resultDate;
string displayDate = string.Empty;
if (DateTime.TryParse(sqlDate, out resultDate))
  displayDate = resultDate.ToString("yyyy-MM-dd");

Console.WriteLine("Only Date: " + displayDate);

Thanks

Jignesh Kumar3y ago
use this one in sql query CONVERT(char(10), orderedDate ,126),
```
select top 10  CONVERT(char(10), orderedDate ,126) as formatedDate from ci_orders
```
+2
Rajanikant Hawaldar3y ago
```
dt.ToString("yyyy-MM-dd");
```
https://www.c-sharpcorner.com/blogs/date-and-time-format-in-c-sharp-programming1
+2
Naresh Beniwal3y ago
https://stackoverflow.com/questions/3025361/c-sharp-datetime-to-yyyymmddhhmmss-format
+2