You put the datetime delimiter in front of it.
If you don't do that, it won't work.
If you put just date, you'll get just the date.
If you put just time, you get the time.
We want datetime, column name plus 978307200,
comma single tick unixepoch single tick.
Local time is up to you.
Now, the only time I use local time--
two instances here.
The first, if I'm doing validation on my own device--
I know I live in Eastern Standard Time.
So like right now, I'm in the recording studio in California.
If I tried to do testing from my local device,
it would confuse me because I would have
to think Pacific to Eastern.
So I would choose local time so it would convert it
for me because I know where I was when I did my testing.
Now, if I did the testing here, I
would also want to do local time for here because it
would choose Pacific.
If you don't choose that, it's going to put it in UTC.
You are going to see your VMs are UTC.
So if you don't choose local time, that's fine.
Then we do the same thing a second time.
We do datetime column name plus 97837200 comma single tick
unixepoch single tick comma.
And I'm going to show you what this looks like.
So here we have all of the converted timestamps.
They look good.
This is Mac.
I'm going to show you Unix.
And I'll make some mistakes for fun.
So I'm going to say datetime, and I'm
going to hopefully spell it right.
Update time is my timestring or my column.
And you notice how it says modify or modifier, modifier,
modifier-- depends on what it is.
So let me do it wrong.
I'm going to do it as a Mac, 978307200 comma single tick
unixepoch.
And if you look at these timestamps, here's the issue.
It doesn't give you an error.
It's like yeah, 2047 at 11/11.
No.
That's not right.
So now you go back, and you're like, great.
So you just do the column, and you're like, OK,
that looks a little more legible.
So we did datetime column name unixepoch.
Here we go.
Now, what if I thought it was 13 digits in length?
13 digits means divide by 1,000.
1/18/1970-- not quite right.
I would be lying to you if I did not tell you,
for every single query I wrote about 5
and 1/2 years ago, this is what I did every single time.
I was like, umm, I'm going to try them all.
Don't do that.
What I recommend is, if you need something--
and I will actually--
I will make note of this.
I'm going to put this in your Dropbox.
Lee Crognale did--
I have a lunchtime show called Life has no ctrl alt del.
It won the Forensic Forecast Award in 2021.
Lee did a presentation on it where
she showed all the different ways
times can exist in a database and how to convert them.
She created a zip file that has practice databases, the queries
that you need to run, and just example walkthroughs.
I'm going to put that as bonus items
in your course Dropbox for day one.
This course is taught in sections.
You will see the Dropbox will say,
like, day one, day two, day three, day four, day five,
day six, add-ons, gas, all kinds of different things.
Associate the section to a day, and look there.
And you'll find it, so you'll get more practice with it.
It's a really good show.
You can also watch the show.
If you go out to Life has no ctrl alt del,
and you google SQLite, you'll see all the SQLite
shows that ever existed.
They're 30 minutes in length, and they're well
worth your time.
Take a look at it.
So the difference--
Unix Epoch, Mac with the 97837200--
crystal clear, right?
This is the point where I wish I could see your faces,
and you're, like, what is happening to me?
She's insane.