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?

Mani Kandan · 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 + ' ;