MySQL Select Time from Timestamp Example

Hi Friends,

I am going to explain you example of MySQL select time from timestamp example. You will learn MySQL select time from timestamp code example. get only the date in timestamp in MySQL.

This article will give you simple example of convert timestamp to date in SQL query. We will use get search how to find the time from timestamo for a given date in MySQL.

So let's start following example.

Table : users

Solution SQL Query:

SELECT 
    id, 
    name, 
    email, 
    TIME(created_at) as time 
FROM `users`

Output:

I hope it will help you...