<SYSTEM_TASK:>
Given the following text description, write Python code to implement the functionality described below step by step
<END_TASK>
<USER_TASK:>
Description:
 Title
Step1:  Get Current Date
Step2:  Get Current Date And Time
Step3:  Compute A UNIX timestamp into a date and time
Step4:  Compute A UNIX timestamp into a date and time and convert to the local timezone.
Step5:  Compute The Day Of The Week
<ASSISTANT_TASK:>
Python Code:
# Ignore
%load_ext sql
%sql sqlite://
%config SqlMagic.feedback = False
Explanation: Title: Dates And Times
Slug: dates_and_times
Summary: Dates and times in SQL. 
Date: 2016-05-01 12:00
Category: SQL
Tags: Basics
Authors: Chris Albon  
Note: This tutorial was written using Catherine Devlin's SQL in Jupyter Notebooks library. If you have not using a Jupyter Notebook, you can ignore the two lines of code below and any line containing %%sql. Furthermore, this tutorial uses SQLite's flavor of SQL, your version might have some differences in syntax.
For more, check out Learning SQL by Alan Beaulieu.
End of explanation
%%sql
-- Select the current date
SELECT date('now');
Explanation: Get Current Date
End of explanation
%%sql
-- Select the unix time code '1200762133'
SELECT datetime('now', 'unixepoch');
Explanation: Get Current Date And Time
End of explanation
%%sql
-- Select the unix time code '1169229733'
SELECT datetime(1169229733, 'unixepoch');
Explanation: Compute A UNIX timestamp into a date and time
End of explanation
%%sql
-- Select the unix time code '1171904533' and convert to the machine's local timezone
SELECT datetime(1171904533, 'unixepoch', 'localtime');
Explanation: Compute A UNIX timestamp into a date and time and convert to the local timezone.
End of explanation
%%sql
-- Select the the day of this week (0 = Sunday, 4 = Thursday)
SELECT strftime('%w','now');
Explanation: Compute The Day Of The Week
End of explanation
<END_TASK>