How to reject same time data before saving to Sqlite Net Pcl

Question

basic from: https://docs.microsoft.com/en-us/samples/xamarin/xamarin-forms-samples/getstarted-notes-database/
In this example using DateTime.Now to save to database. Well, if I use DatePicker. Assuming the date data already exists.
How to display DisplayAlert , if the input from DataPicker is the same as previous data.
Thank you in advance.
#Xamarin.Forms
#Sqlite-net-pcl

Amit Gupta · Answer

You can use date function;
select date('2021-02-09 18:40:34')
Output- 2021-02-09