datetime error in C#

Abhilash J A

9y861Visual Basic .NET

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",

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Accepted 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 Mohapatra9y ago
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
Abhilash J A9y ago
@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 + "'";
Manas Mohapatra9y ago
What is the error now?