How can I remove the time with the date of the database in the data retrieval

Question

How can I remove the time with the date of the database in the data retrieval

Javier R 211

How can I remove the time with the date on a datePicker on sql server c #. Example ddMMYYY 00:00:00

Accepted answer

5 additional answers

Your answer

Answer 1

Viorel 122.6K

Try this binding:

<TextBlock Text="{x:Bind DuoDate.ToShortDateString()}" ...

Answer 2

Guoxiong 8,206

Try to use Format function:

SELECT FORMAT(GETDATE(), 'ddMMyyyy');

Javier R 211 Reputation points

2021-05-07T06:48:48.657+00:00

This select cast goes in the sql set-up

Answer 3

Yitzhak Khabinsky 26,586

Another way is via CASTing:

 SELECT CAST(GETDATE() AS DATE);

Answer 4

Olaf Helper 47,436

on a datePicker on sql server

There is not DatePicker or any other control on SQL Server side.

Use DateTime.Date Property to get the date without time potion.

Answer 5

Viorel 122.6K

If you never need the time, then use a date column instead of datetime in SQL.

Javier R 211 Reputation points

2021-05-07T16:27:06.473+00:00
I have on the table date problem this in the part of receiving data.

cmd.Parameters.Add("@duoDate", SqlDbType.Date).Value = DateNac.SelectedDate.Value.Date;

the problem i s here :
pettable.DuoDate = reader.GetDateTime(1);
AryaDing-MSFT 2,916 Reputation points

2021-05-12T02:47:47.543+00:00

@Javier R Could you please provide us the error message?
Viorel 122.6K Reputation points

2021-05-12T05:43:12.667+00:00

Maybe you should execute 'pettable.DuoDate = reader.GetDateTime(1).Date'?
Javier R 211 Reputation points

2021-05-12T10:13:02.217+00:00

the problem is: when displaying the data in the recovery I get the date and time I want to remove the time when displaying the data.
Javier R 211 Reputation points

2021-05-12T10:15:32.727+00:00

I have it : pettable.DuoDate = reader.GetDataTime(1).Date;

but when displaying the data I get the date (which is chosen in the DataaPicker) and the time
AryaDing-MSFT 2,916 Reputation points

2021-05-14T06:08:20.907+00:00

@Javier R There is no "strictly-Date" structure. Although you use .Date to format DataTime, it only changes the time to 00:00:00. You must use string conversion to achieve the complete date structure. For example, you could use ToShortDateString() method convert it as “MM-dd-yyyy” string format.
Viorel 122.6K Reputation points

2021-05-14T08:00:43.303+00:00

Where is it displayed?
Javier R 211 Reputation points

2021-05-15T19:47:23.207+00:00

Thsisproblem I want to take the time out
Viorel 122.6K Reputation points

2021-05-16T07:43:13.947+00:00

How is it displayed by your program? What kind of control or technique are you using to show the date?

Javier R 211

This is code for inseet for table

 cmd.Parameters.Add("@duoDate", SqlDbType.Date).Value = DateNac.SelectedDate.Value.DateTime;

this is code xaml where the table record is displayed

<TextBlock   Text="{x:Bind DuoDate}" Grid.Column="3" VerticalAlignment="center"  FontSize="{StaticResource SmallFontSize}"/>

this is code select for table

 pettable.DuoDate = reader.GetDateTime(1).Date;

Share via

How can I remove the time with the date of the database in the data retrieval

5 additional answers

Your answer