Teradata SQL: Date fmt/xform timestamp

Programming
,
1

I need to convert lastupdatedate to the format dd-mm-yyyy hh.mm.ss,000000.

SELECT CAST(SUBSTRING(lastupdatedate, 1, 9) AS DATE FORMAT 'DD-MM-YYYY') ||
       SUBSTRING(lastupdatedate, 11) AS new_date_format
FROM table_name;

The lastupdatedate column needs to be converted to the format dd-mm-yyyy hh.mm.ss,000000. To achieve this, the following query can be used:

SELECT CAST(SUBSTRING(lastupdatedate, 1, 9) AS DATE FORMAT 'DD-MM-YYYY') ||
       SUBSTRING(lastupdatedate, 11) AS new_date_format
FROM table_name;
2

The lastupdatedate column needs to be converted to the format dd-mm-yyyy hh.mm.ss,000000. To achieve this, the following query can be used:

SELECT CAST(SUBSTRING(lastupdatedate, 1, 9) AS DATE FORMAT 'DD-MM-YYYY') ||
       SUBSTRING(lastupdatedate, 11) AS new_date_format
FROM table_name;