Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cindyp
Starting Member
1 Post |
 Posted - 2014-09-22 : 21:03:03
|
| I am using SQ Lite. I have completed just about everything I need to extract the messages, date, phone number, actual text message,etc. However, I need to code in AM/PM values. In addition, when I go to execute the command, it does not go through all the records. There are over 7000 data lines.This is very important, it is for a child custody case happening tomorrow morning. I am NEW NEW NEW and self taught, so any help would be appreciated. In addition, when I export this to a CSV file, none of the SQL commands filter over to the CSV file. I need to print this for court tomorrow. My grandsons custody is at risk. Please Help!SELECT datetime(date + 978307200, 'unixepoch','-4 hours'), handle.id, is_from_me, text FROM message JOIN handle ON message.handle_id=handle.ROWID ORDER BY 1; |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-09-22 : 21:26:54
|
Is site is on Microsoft SQL Server. SQL Lite is not a "SQL Server"
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
|
|
Extracting data from IPhone sms file