B4J Question Error using <strftime> in SQLite with B4J

Mariano Ismael Castro · Friday at 7:45 PM

Hi, I'm trying to display a time that is in 24 hour format to a 12 hour format. To do this conversion I'm trying to use SQLite's <strftime> but I can't get it to work in B4J. There is no error, the query simply returns <null>. It's worth mentioning that if I test the query in other programs to manage SQLite databases, this query works.
I'm attaching an example in case someone can help me, regards.

LucaMs · Friday at 11:54 PM

Download and use:

sqlite-jdbc-3.47.0.0

from here:
https://github.com/xerial/sqlite-jdbc/releases

and your project will work.

LucaMs · Friday at 11:54 PM

Download and use:

sqlite-jdbc-3.47.0.0

from here:
https://github.com/xerial/sqlite-jdbc/releases

and your project will work.

Mariano Ismael Castro · 2024-11-23T00:00:39+0000

LucaMs said:
sqlite-jdbc-3.47.0.0

Thank you very much for your help, I had tried with sqlite-jdbc-3.34.0 and it didn't work. Thank you very much

drgottjr · 2024-11-23T00:57:21+0000

your hora_temp format (03:10:00) is wrong. that's why you get null's
you either have to store the times in a format that sqlite understands or write your own routine to convert the hora_temp fields to the format you want.
check the sqlite dox.
sqlite accepts:
ISO-8601 A text string that is an ISO 8601 date/time value. Example: '2025-05-29 14:16:00'
Julian day number The number of days including fractional days since -4713-11-24 12:00:00 Example: 2460825.09444444
Unix timestamp The number of seconds including fractional seconds since 1970-01-01 00:00:00 Example: 1748528160

your format is not understood.

LucaMs · 2024-11-23T10:26:38+0000

drgottjr said:
your hora_temp format (03:10:00) is wrong. that's why you get null's
you either have to store the times in a format that sqlite understands or write your own routine to convert the hora_temp fields to the format you want.
check the sqlite dox.
sqlite accepts:
ISO-8601 A text string that is an ISO 8601 date/time value. Example: '2025-05-29 14:16:00'
Julian day number The number of days including fractional days since -4713-11-24 12:00:00 Example: 2460825.09444444
Unix timestamp The number of seconds including fractional seconds since 1970-01-01 00:00:00 Example: 1748528160

your format is not understood.

No, that format, hh:mm:ss, is correct, even for SQLite. A newer library was needed; in fact, changing libraries, the project returns correct values, not nulls.

B4J Question Error using <strftime> in SQLite with B4J

Mariano Ismael Castro

Active Member

Attachments

LucaMs

LucaMs

Expert

Mariano Ismael Castro

Active Member

drgottjr

Expert

LucaMs

Expert

Similar Threads

B4J Question Error using <strftime> in SQLite with B4J

Mariano Ismael Castro

Active Member

Attachments

LucaMs

Expert

Mariano Ismael Castro

Active Member

drgottjr

Expert

LucaMs

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency