---
title: "How to Extract Date from Timestamp"
description: "The best idea to get DATE and TIME from Timestamp. This is one of the better way to use DATE function in SQL query. It is also a best DATE example."
url: https://srinimf.com/2017/01/05/how-to-extract-date-from-timesmp/
date: 2017-01-05
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2017/01/date-from-timestamp.jpg?fit=1200%2C900&ssl=1
categories: ["DB2"]
tags: ["db2 date and time functions", "How to Extract DATE and TIME from Timestamp"]
type: post
lang: en
---

# How to Extract Date from Timestamp

Extracting the date and time independently from a timestamp is also very easy:

## Use Date and Time Functions in SQL Query [to Extract](https://srinimf.com/2017/01/21/the-best-way-extract-day-from-date-in-sql/) Date and Time from Timestamp

DATE (current timestamp)
TIME (current timestamp)

**Related Posts**

- [How to Extract DATE and TIME from TIMESTAMP: DB2](https://srinimf.com/2023/12/27/how-to-get-date-and-time-from-timestamp-in-db2/)DateDecember 27, 2023
- [NEXT_DAY Vs DAYNAME Top SQL Examples](https://srinimf.com/2020/07/12/next_day-vs-dayname-top-sql-examples/)DateJuly 12, 2020
- [SQL EXTRACT Function: How to Get Month, Day, Year](https://srinimf.com/2019/01/28/db2-date-sql-queries-to-use-in-your-current-project/)DateJanuary 28, 2019

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2017%2F01%2F05%2Fhow-to-extract-date-from-timesmp%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2017%2F01%2Fdate-from-timestamp.jpg%3Ffit%3D1200%252C900%26ssl%3D1&description=How%20to%20Extract%20Date%20from%20Timestamp)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2017/01/05/how-to-extract-date-from-timesmp/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2017/01/05/how-to-extract-date-from-timesmp/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2017/01/05/how-to-extract-date-from-timesmp/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2017/01/05/how-to-extract-date-from-timesmp/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20to%20Extract%20Date%20from%20Timestamp&body=https%3A%2F%2Fsrinimf.com%2F2017%2F01%2F05%2Fhow-to-extract-date-from-timesmp%2F&share=email)
-

### Like this:

Like Loading…