Using TO_CHAR to format timestamps [email protected] (Simon Hutchinson)

​I use the SQL scalar function TO_CHAR all of the time to format numbers, inserting thousand separator characters. I can also use it for formatting timestamps.
In the following examples I am going to show how easy this, and it appears to duplicate a lot of the functionality of the EXTRACT scalar function.
In these examples I am going to show what I can do with a timestamp column, TIMESTAMP1, in a SQL DDL table, TESTTABLE.
Let me show you some examples of what I can do.
Read more » Read More 

Verified by MonsterInsights