Exporting to CSV from logbook, how to get the date?

Topics relating to online racing and training with 3rd party software.
Post Reply
roy649
Paddler
Posts: 18
Joined: March 7th, 2019, 1:57 pm

Exporting to CSV from logbook, how to get the date?

Post by roy649 » March 21st, 2019, 10:49 pm

If I export to CSV, I get a file with a name like concept2-result-37321928.csv. I'm guessing the digit string somehow encodes the date of the workout, but I can't figure out the format. It's certainly not a unix timestamp.

User avatar
Citroen
SpamTeam
Posts: 8074
Joined: March 16th, 2006, 3:28 pm
Location: A small cave in deepest darkest Basingstoke, UK

Re: Exporting to CSV from logbook, how to get the date?

Post by Citroen » July 5th, 2021, 12:22 pm

It does NOT encode the date. It looks like a randomly assigned sequence number (probably from something like

Code: Select all

CREATE TABLE rowdata(workoutid int NOT NULL AUTO_INCREMENT, ...)
in the SQL database that holds the workout data).

Post Reply