HOw to truncate a date from Time stamp to use in Business Objects

Database
Fan

HOw to truncate a date from Time stamp to use in Business Objects

Hello Guys,

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?

Regards

Sara

2 REPLIES
Junior Contributor

Re: HOw to truncate a date from Time stamp to use in Business Objects

Hi Sara,

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)

Fan

Re: HOw to truncate a date from Time stamp to use in Business Objects

Thanks for responding Dieter.

It worked.