WEBVTT

00:00:01.794 --> 00:00:04.604 align:middle line:84%
OK, behind the scenes,
what are we going to do?

00:00:04.604 --> 00:00:09.594 align:middle line:84%
We have a table
called ZKIKMESSAGE.

00:00:09.594 --> 00:00:13.104 align:middle line:84%
We want to see the user, the
timestamp, the timestamp,

00:00:13.104 --> 00:00:14.194 align:middle line:90%
the body.

00:00:14.194 --> 00:00:16.704 align:middle line:84%
Now, look at that,
timestamp, timestamp.

00:00:16.704 --> 00:00:19.494 align:middle line:84%
This is where people are
like, what is the difference?

00:00:19.494 --> 00:00:20.844 align:middle line:90%
Create test data.

00:00:20.844 --> 00:00:22.704 align:middle line:90%
That is my best advice to you.

00:00:22.704 --> 00:00:26.374 align:middle line:84%
Create test data that is going
to say what you think it is.

00:00:26.374 --> 00:00:28.314 align:middle line:90%
Download KIKMESSAGE.

00:00:28.314 --> 00:00:29.874 align:middle line:90%
Send a message.

00:00:29.874 --> 00:00:30.894 align:middle line:90%
One is probably sent.

00:00:30.894 --> 00:00:32.009 align:middle line:90%
One is probably received.

00:00:32.009 --> 00:00:33.384 align:middle line:84%
You could have
different updates.

00:00:33.384 --> 00:00:34.814 align:middle line:90%
There's all kinds of things.

00:00:34.814 --> 00:00:37.314 align:middle line:84%
So what we need to do is we
need to write a query that says,

00:00:37.314 --> 00:00:39.864 align:middle line:90%
show us just these things.

00:00:39.864 --> 00:00:42.804 align:middle line:84%
If I quizzed you on timestamps
right now, if I said,

00:00:42.804 --> 00:00:47.364 align:middle line:84%
what's a second indicator that
this came from an iOS device?

00:00:47.364 --> 00:00:51.324 align:middle line:84%
Your answer should
be the timestamp.

00:00:51.324 --> 00:00:53.969 align:middle line:84%
So this timestamp,
it starts with a 4.

00:00:53.969 --> 00:00:55.344 align:middle line:84%
If it starts with
a 4, it's going

00:00:55.344 --> 00:00:58.104 align:middle line:84%
to be a Mac timestamp,
very important to remember.

00:00:58.104 --> 00:01:01.674 align:middle line:84%
And I'm going to keep giving you
these hints on these timestamps

00:01:01.674 --> 00:01:04.151 align:middle line:84%
and quizzing you, even though
you're not answering me.

00:01:04.151 --> 00:01:05.484 align:middle line:90%
In my mind, you're answering me.

00:01:05.484 --> 00:01:07.109 align:middle line:84%
I'm going to keep
quizzing you on this.

00:01:07.109 --> 00:01:10.134 align:middle line:84%
So we have the Z, and that
timestamp starts with a 4.

00:01:10.134 --> 00:01:11.784 align:middle line:90%
It's 100% Apple.
