Signed-off-by: Miika Turkia <[email protected]>
---
parse-xml.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/parse-xml.c b/parse-xml.c
index 7f00294..62eceaa 100644
--- a/parse-xml.c
+++ b/parse-xml.c
@@ -2890,7 +2890,7 @@ int parse_divinglog_buffer(sqlite3 *handle, const char
*url, const char *buffer,
char *err = NULL;
target_table = table;
- char get_dives[] = "select Number,strftime('%s',Divedate || ' ' ||
Entrytime),Country || ' - ' || City || ' - ' ||
Place,Buddy,Comments,Depth,Divetime from Logbook where UUID not in (select UUID
from DeletedRecords)";
+ char get_dives[] = "select Number,strftime('%s',Divedate || ' ' ||
ifnull(Entrytime,'00:00')),Country || ' - ' || City || ' - ' ||
Place,Buddy,Comments,Depth,Divetime from Logbook where UUID not in (select UUID
from DeletedRecords)";
retval = sqlite3_exec(handle, get_dives, &divinglog_dive, handle, &err);
--
2.1.4
_______________________________________________
subsurface mailing list
[email protected]
http://lists.subsurface-divelog.org/cgi-bin/mailman/listinfo/subsurface
