I am creating a Universe on top of Teradata for the first time and need to trucate a date from time stamp field. How can I do that. PLease explain in simplest words as I am newbie.
it should be like
Select (TRUNC (DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.START_DT) as Start Date,
Can anyone please correct this syntax and help me?
when you CAST a timestamp to a DATE the time part is truncated:
CAST(DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.START_DT AS DATE)