This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How can I remove the time with the date on a datePicker on sql server c #. Example ddMMYYY 00:00:00
Try this binding:
<TextBlock Text="{x:Bind DuoDate.ToShortDateString()}" ...
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 3%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Try to use Format function:
SELECT FORMAT(GETDATE(), 'ddMMyyyy');
This select cast goes in the sql set-up
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Another way is via CASTing:
SELECT CAST(GETDATE() AS DATE);
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.
If you never need the time, then use a date column instead of datetime in SQL.
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);
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 46%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
@Javier R Could you please provide us the error message?
Maybe you should execute 'pettable.DuoDate = reader.GetDateTime(1).Date'?
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.
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
@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.
Where is it displayed?
Thsisproblem I want to take the time out
How is it displayed by your program? What kind of control or technique are you using to show the date?
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;