0000929: Timestamp Fields shows always 0 Dates

Notes
(0000233) sharpplus (administrator) 2009-02-27 07:36	Thank you for your bug report , I will check it

(0000234) sharpplus (administrator) 2009-02-28 08:30	sorry, I can not duplicate the problem, I guess it maybe caused by Germany region setting or your data format or type mapping ? would you please post a little database which can show the problem. best gards

(0000237) mreisch (reporter) 2009-03-01 05:03	The screenshot you see was made with the sample database, that was installed with sqlite developer. BTW I like the sqlite developer very much, great piece of software. I think I will order it for my private use.

(0000238) sharpplus (administrator) 2009-03-02 09:20	I guess the problem was caused by the difference of region settings between Germany and Japanese System. Our sample db's data was created under Japanese system settings. Would you please open your sqlite developer and execute menu command Options \| Options , then in the options dialog select Tree Node General \| DataType , then change the DateTime Setting's Date Separator to '/', DateFormat to 'yyyy/MM/dd' (please open the attachment date2.jpg to see my setting), and open the table again ? Best regards

(0000239) mreisch (reporter) 2009-03-02 11:08	When I change the DateFormat as you wish then the Timestamps in the sample DB was shown correct. But not in my DB which I had filled with my german system. In my Delphi Application the timestamps was shown correctly.

(0000241) sharpplus (administrator) 2009-03-03 09:21	sorry, I do not know your problem very clearly. I just change my date format setting to germany region settings(Date Separator ='.' and DateFormat='dd.MM.yyyy' like attachment Germany2.jpg) and then I create a table with a datetime field , and edit the date , it looks like ok (see Germany1.jpg). in your db, are the timestamp data saved as dd.MM.yyyy format string? In SQLite Developer , the timestamp data will be converted from string to datetime using Delphi StrToDateTime function. If your time data were not saved as string for example integer, it will explain the result you observed. If you still can not get the data be shown correctly , would you please post a sample db?

Issue History
Date Modified	Username	Field	Change
2009-02-27 07:27	mreisch	New Issue
2009-02-27 07:27	mreisch	File Added: sql_error.jpg
2009-02-27 07:36	sharpplus	Note Added: 0000233
2009-02-28 08:30	sharpplus	Note Added: 0000234
2009-03-01 05:03	mreisch	Note Added: 0000237
2009-03-02 09:18	sharpplus	File Added: date2.jpg
2009-03-02 09:20	sharpplus	Note Added: 0000238
2009-03-02 11:08	mreisch	Note Added: 0000239
2009-03-03 09:13	sharpplus	File Added: Germany2.jpg
2009-03-03 09:14	sharpplus	File Added: Germany1.jpg
2009-03-03 09:21	sharpplus	Note Added: 0000241

Relationships