1 Attachment(s)
Another Tech support question (excel conversion from EPOCH )
Since tech support is so great on this outdoor blog, I figured I would ask mine. I have 98,137 quality control recording files from the Department of Revenue. I need to archive them on a different drive but make them accesible if needed rarely on the different server. So all the files are in mp3 format. I just need to make a master index so they know what file is associated with what timestamp. The problem is the timestamp on the DB is in EPOCH time and the output they look at from the software is in "human dates". So I need to convert from the EPOCH time stamp (or unix timestamp) into normal time. I found a website that will do 500 at a time but that would take me forever. www.epochconverter.com
I was thinking I could export the list into an excel spreadsheet and then input a conversion formula, but have had no luck finding one. I can output my query to a text file only with this application but it can run SQL queries. The "actiondate" is the field in question. I will attach a small text file of my query and data. Does anyone know a way to do this or have a better idea? Maybe I'm going about this the wrong way? Maybe there is a way to even do this an SQL query? Some days I wish I was a DBA :P
Re: Another Tech support question (excel conversion from EPO
Quote:
Originally Posted by deathcricket
I found a website that will do 500 at a time but that would take me forever.
then i suggest you get started right away. :haha:
1 Attachment(s)
Re: Another Tech support question (excel conversion from EPO
Quote:
Originally Posted by deathcricket
Since tech support is so great on this outdoor blog, I figured I would ask mine. I have 98,137 quality control recording files from the Department of Revenue
I was able to write a program in MATLAB that converted your text file to the same string output as the www.epochconverter.com. I have no idea what SQL query means. If you have access to MATLAB I can send you the code. If you don
Re: Another Tech support question (excel conversion from EPO
Quote:
Originally Posted by deathcricket
I can output my query to a text file only with this application but it can run SQL queries. Maybe there is a way to even do this an SQL query?
Select *
[/thread] (you'll need to know SQL to get this)
other query's that might be helpful
SELECT *
FROM users
WHERE Clue >0
0 Rows retunred
SELECT Girl
FROM Pub
WHERE Single = 1
AND Desperate = 1
AND Will_sleep_with_me >= 1
http://shop.cafepress.com/sql
Re: Another Tech support question (excel conversion from EPO
Quote:
Originally Posted by trackrunner
SELECT Girl
FROM Pub
WHERE Single = 1
AND Desperate = 1
AND Will_sleep_with_me >= 1
**There are (0) matches for your search.**
Re: Another Tech support question (excel conversion from EPO
[quote=James_B_Wads2000]
Quote:
Originally Posted by deathcricket
Since tech support is so great on this outdoor blog, I figured I would ask mine. I have 98,137 quality control recording files from the Department of Revenue
I was able to write a program in MATLAB that converted your text file to the same string output as the www.epochconverter.com. I have no idea what SQL query means. If you have access to MATLAB I can send you the code. If you don
1 Attachment(s)
Re: Another Tech support question (excel conversion from EPO
Quote:
Originally Posted by Sombeech
Quote:
Originally Posted by trackrunner
SELECT Girl
FROM Pub
WHERE Single = 1
AND Desperate = 1
AND Will_sleep_with_me >= 1
**There are (0) matches for your search.**
Not what I got. Sorry you didn't have luck on your part.