Bug 363068

Summary:	Can't change table field type to Time
Product:	[Applications] KEXI	Reporter:	Albrecht Will <albrecht.will>
Component:	Tables	Assignee:	Kexi Bugs <kexi-bugs>
Status:	RESOLVED UPSTREAM
Severity:	normal	CC:	adam, inksi, saavedra.ibarra, staniek
Priority:	NOR
Version:	2.9.11
Target Milestone:	---
Platform:	Arch Linux
OS:	Linux
Latest Commit:		Version Fixed In:
Attachments:	during cvs-import result in form Result in report result in form_new Kexi 3.2: Importing CSV with date/time/date-time values Resulting KEXI file: Imported CSV with date/time/date-time values Imported CSV file with date/time values

Description Albrecht Will 2016-05-14 13:54:27 UTC

If I use the usual way of creating a table with editing it, I only find the data-typ "date/time". In the right property-table there is a sub-property of "date/time" = "time". Unfortunately this is not persistent. In this way its for now not possible to create time-fields.
If I go the path "B" I create a table with LO, create a column (field) with "time" (example 15:00).
Importing this as cvs, kexi recognizes the field really as "time" (!) but finally the import ends in a date.
Am I right, that earlier versions of kexi worked better in this case? Somehow I remember.

Reproducible: Always

Comment 1 Albrecht Will 2016-05-14 13:55:43 UTC

Created attachment 98960 [details]
during cvs-import

Comment 2 Albrecht Will 2016-05-14 13:56:06 UTC

Created attachment 98961 [details]
result in form

Comment 3 Albrecht Will 2016-05-14 13:56:43 UTC

Created attachment 98962 [details]
Result in report

Comment 4 Albrecht Will 2016-05-14 14:03:45 UTC

Created attachment 98963 [details]
result in form_new

The image "result in form" must be replaced by the image "result in form_new"

Comment 5 Jarosław Staniek 2018-12-15 23:28:32 UTC

*** Bug 371894 has been marked as a duplicate of this bug. ***

Comment 6 Jarosław Staniek 2018-12-31 12:07:36 UTC

Regarding:
> If I use the usual way of creating a table with editing it, I only find the 
> data-typ "date/time". In the right property-table there is a sub-property of 
> "date/time" = "time". Unfortunately this is not persistent. In this way its for 
> now not possible to create time-fields.

I confirm this works as expected in 3.1 or even in 3.0. 2.9 can't be fixed. 

However this topic is not related to the summary of the bug report (Forms/report) so I will update the summary.

I'll also test the CSV topic and create bug if needed. 

In the future it's better to keep on topic in one bug report -- here are three topics already if I understood them correctly.

Comment 7 Jarosław Staniek 2018-12-31 12:25:40 UTC

Created attachment 117205 [details]
Kexi 3.2: Importing CSV with date/time/date-time values

Comment 8 Jarosław Staniek 2018-12-31 12:26:24 UTC

Created attachment 117206 [details]
Resulting KEXI file: Imported CSV with date/time/date-time values

Comment 9 Jarosław Staniek 2018-12-31 12:30:43 UTC

Created attachment 117207 [details]
Imported CSV file with date/time values

Comment 10 Jarosław Staniek 2018-12-31 12:34:20 UTC

Please find attachment from comments 7, 8, 9 to see evidence of support for proper date/time CSV import in KEXI 3.2. I think it was OK like this in 3.1.0 too after we fixed unrelated regression of https://bugs.kde.org/show_bug.cgi?id=386102.