“Even I don't’ wake up looking like Cindy Crawford.”
- Cindy Crawford
The FORMAT Command
SELECT Current_Date (FORMAT ‘mm-dd-yy’) ;
In this example, we are using it for dates. All dates in Teradata are stored in the systems as an INTERGERDATE. This allows it to be read and formatted easily.
The Basics of the FORMAT Command
When you put ‘mm’, you will get the month as a two digit number.
When you put ...