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: 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 SQL ...   Queries: 1) SELECT date, TO_CHAR(date,'HH12:MI:SS') FROM table Get the Pagila Database:    • How to Load a Sample PostgreSQL Database i...   Support the Channel: 1) Subscribe: 2) DataCamp: 3) Udacity: