Exporting to CSV from logbook, how to get the date?
Exporting to CSV from logbook, how to get the date?
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.
- 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?
It does NOT encode the date. It looks like a randomly assigned sequence number (probably from something like
in the SQL database that holds the workout data).
Code: Select all
CREATE TABLE rowdata(workoutid int NOT NULL AUTO_INCREMENT, ...)