How to use the DATE_TRUNC Function in SQL (vs. TO_CHAR)

preview_player
Показать описание
In this tutorial, you'll learn how to use the DATE_TRUNC function in SQL to optimize queries using dates!

Queries:
1) Truncate for the day: SELECT date, DATE_TRUNC('day',date) FROM table
2) Do some truncated date math: SELECT DATE_TRUNC('day',date1)-DATE_TRUNC('day',date2) FROM table

Support the Channel:
  1. Becoming a Data Scientist
  2. becoming a data scientist
  3. becomingads.com
  4. data science
  5. data scientist
  6. date_trunc
Рекомендации по теме
Oracle Tutorial - 0:15:41

Oracle Tutorial - Date Functions ROUND | TRUNC

How to use 0:07:24

How to use the DATE_TRUNC Function in SQL (vs. TO_CHAR)

Working with Dates 0:04:19

Working with Dates (SQL) - EXTRACT, DATE_PART, DATE_TRUNC, DATEDIFF

Tableau - DATETRUNC 0:04:08

Tableau - DATETRUNC function explained with example

Date Functions: DATENAME, 0:30:30

Date Functions: DATENAME, DATEPART, DATETRUNC, DAY | #Tableau Course #88

Date Manipulation - 0:03:13

Date Manipulation - trunc

Just know How 0:02:54

Just know How Truncate function works in Oracle - Cool videos #truncatefunction

DATETRUNC( ) Function 0:05:19

DATETRUNC( ) Function || #Tableau Functions

Oracle SQL Lab 0:07:08

Oracle SQL Lab 1 - Objective 8: TRUNC and ROUND with dates

Use of TRUNC 0:01:59

Use of TRUNC Function for separating Date and Time in Excel sheet

date datatype with 0:06:01

date datatype with round and trunc function.

The Excel TRUNC 0:03:32

The Excel TRUNC Function

PostgreSQL: DATE_TRUNC Function 0:01:59

PostgreSQL: DATE_TRUNC Function | How to Truncate Date in PostgreSQL | DATE_TRUNC In PostgreSQL

Difference between DATETRUNC 0:08:28

Difference between DATETRUNC and DATEPART in TABLEAU

SQL Date & 0:43:27

SQL Date & Time Functions | Datepart, Datename, Datetrunc, Eomonth | #SQL Course 15

Trunc ( ) 0:00:34

Trunc ( ) - Seperate Date-time in Excel #shorts #excel #exceltips #exceltutorial

BigQuery DATE & 0:27:46

BigQuery DATE & TIME Functions|EXTRACT, TRUNC, FORMAT, PARSE

DATE FUNCTIONS - 0:05:02

DATE FUNCTIONS - DATE-TRUNC() AND LAST_DAY() - Bigquery

Exploring the DATETRUNC 0:02:48

Exploring the DATETRUNC Function in Tableau

Concatenate formula in 0:00:16

Concatenate formula in excel

split date and 0:00:42

split date and time using Trunc function

How to Truncate 0:01:17

How to Truncate Date in Oracle

Trunc Formula Lagana 0:00:50

Trunc Formula Lagana sikhe #shorts #tricks #date #time #excelformula

Date & Time 0:00:27

Date & Time Trunc function #shortsfeed #shorts #exceltips

Комментарии
Автор

Thank you so much for breaking this down into simple words to connect the concepts for us N00bs!!! Greatly appreciate the effort you put in dude. A thousand thank you's friend!!!!

PhoenixJade
Автор

Great tutorial. Precise and easy to understand

kanknw
Автор

Just what I needed and you explained very well and in simple.
Thank you so much

mdimranhussain
Автор

thanks helped me with date formatting.

skkitchenstore
Автор

Can we use date_diff('day', return_date, rental_date)
???

reigngamer
Автор

In python, I'd just use a data type converter to convert the day back to a numeric. Would I be correct in saying that an alternative method would be to use the CAST function to do a similar job in Postgres SQL?

ssol
Автор

Hi again. Which is better in general between SQL Server and PostgreSQL - which I realized is what you're using

joshsmart
Автор

Am I able to group by the product of a distinct 'day' date?

mhuppman
Автор

How do you then filter on these dates (i.e. greater than or between dates x & y)?

mhuppman
Автор

Just so you'll know, some of your links led to a demand for $399. The PC became locked and demanded a fake call to Microsoft. I got out of it by signing off the PC. I'm sure you had nothing to do with it.

michaelbradford
join shbcf.ru