Using the TO_CHAR function in SQL Change Timestamp Output

Описание к видео Using the TO_CHAR function in SQL Change Timestamp Output

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: https://www.becomingads.com/o/youtube
2) DataCamp:
3) Udacity:

Комментарии

Информация по комментариям в разработке