“Even I don’t’ wake up looking like Cindy Crawford.”
– Cindy Crawford
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.
Format the dates for appearance on the report. The actual data doesn’t change.
Current Date = March 20th, 2013
SELECT Current_Date (FORMAT 'mm-dd-yy') ; ...