datetime error in C#

Question

Hello everyone,

Here LogInTime and LogOutTime are datetime datatype. How to solve this error?

AccessDate = (DateTime.TryParse(x.LogOutTime, out parsed)) ? parsed.ToShortDateString() : "Unknown",
AccessTimeFrame = (DateTime.TryParse(x.LogOutTime, out parsed)) ? parsed.ToShortTimeString() : "Unknown",

Nitin Sontakke · Answer

Never ever use ToShortDateString(), etc. These functions are dependent on machine's regional settings which you should never rely on because once deployed on another machine, it will start returning another value. Instead, use something like . ToString("yyyy-MM-dd") which would return reliable value. Try this.

Manas Mohapatra · Answer

It may be your data present is different form than format in SQL query. Please follow below links: http://stackoverflow.com/questions/13020611/how-to-select-rows-by-date-in-sqlite http://stackoverflow.com/questions/2309227/sqlite-select-with-condition-on-date

Manas Mohapatra · Answer

What is the error now?

Abhilash J A · Answer

@Manas Mohapatra, Thanks for replay me. I got answer. Those variable were string format, now changed as Datetime datatype then show error like datetime conversion error. Now its solved AccessDate = DateTime.Parse(x.LogInTime.ToString()).ToShortDateString(), AccessTimeFrame = DateTime.Parse(x.LogInTime.ToString()).ToShortTimeString(), But I have a another question. I am using ADO.NET for SQLite DB select query. After excute this query return null. But there is data exist. The LogInTime is datetime format in SQLite DB. How can I solve this? sql = "SELECT * FROM Tble_UserSetUp inner join Tble_Login on Tble_UserSetUp.Id = Tble_Login.UserId WHERE Tble_Login.UserId='" + UserID + "' and CAST(Tble_Login.LogInTime AS date) ='" + AccessDate + "' or CAST(Tble_Login.LogOutTime AS date) ='" + AccessDate + "'" ;