Using the TO_CHAR function in SQL Change Timestamp Output

Published: 11 January 2020
on channel: Becoming a Data Scientist

15,439

321

Learn how to use the TO_CHAR function to convert timestamps into "pretty" custom-formatted strings in this step-by-step tutorial!

Website with TO_CHAR formatting options: https://www.becomingads.com/o/to_char

NOTE! TO_CHAR is for Date Formatting, while DATE_TRUNC is useful for date math and filtering!

Learn more about DATE_TRUNC: • How to use the DATE_TRUNC Function in...

Queries:
1) SELECT date, TO_CHAR(date,'HH12:MI:SS') FROM table

Get the Pagila Database: • How to Load a Sample PostgreSQL Datab...

Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:

On this page of the site you can watch the video online Using the TO_CHAR function in SQL Change Timestamp Output with a duration of hours minute second in good quality, which was uploaded by the user Becoming a Data Scientist 11 January 2020, share the link with friends and acquaintances, this video has already been watched 15,439 times on youtube and it was liked by 321 viewers. Enjoy your viewing!

1,142