Convert Blob to CSV - date formatting

132
May 07, 2021, at 8:30 PM

Using sqlite3 and a batch file / script, I am able to convert many Blob files to a readable CSV file. To reduce unnecessary CSV formatting I am trying to fine tune the script. The batch file/ script is as follows :

for %%a in (*.db) do sqlite3 -csv -header "%%a" "select 
REPLACE(time(_TimeStamp/1000,'unixepoch'),':','') As Time from log_data">%%~na.csv

The time format output will be display as 230005

Is there a way to adjust the script to also display milliseconds (23005.123) ? and / or Is there a way to adjust the script to display leading zeros for the time, so for example if the time was 43234 it would be 043234

Any help would be appreciated

Rent Charter Buses Company
READ ALSO
Allowing access to USB debugging authorization dialog when in Lock Task Mode

Allowing access to USB debugging authorization dialog when in Lock Task Mode

I'm using device owner to run an app in lock task mode

111
Pagination in a Bootstrap Modal

Pagination in a Bootstrap Modal

I'd like to have pagination in a modal, such that when it refreshes the modal it would stays there

158
Creating text element in seperate cells across columns

Creating text element in seperate cells across columns

What I am trying to do is on button press I will add 4 text elements, each text element in its own cell; beneath its corresponding columnEg

32
groupBy array based on combination of 2 properties

groupBy array based on combination of 2 properties

I want to Group array elements based on combination of 2 properties

140