Teradata Forums / Drivers and UDFs / Teradata / convert timestamp field in Teradata into format 'MMM-YYYY' / Latest Posts

RE: convert timestamp field in Teradata into format 'MMM-YYYY'

sony — Fri, 05 Oct 2007 14:19:19 GMT

Yes shaw you are right. It works in Teradata but in Cognos Report Studio it is not working.

Many Thanks,
Sony

RE: convert timestamp field in Teradata into format 'MMM-YYYY'

Shaw — Fri, 05 Oct 2007 13:27:37 GMT

What is Reportstudio?

I tried this in BTEQ

select CURRENT_TIMESTAMP (FORMAT 'MMM-YYYY');

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

Current TimeStamp(6)
--------------------
Oct-2007

Following expression should work if you are accessing Teradata database with ODBC or .NET Data Provider.

select CAST((CURRENT_TIMESTAMP (FORMAT 'MMM-YYYY')) AS VARCHAR(25));

convert timestamp field in Teradata into format 'MMM-YYYY'

sony — Fri, 05 Oct 2007 12:59:37 GMT

Hi All,

I am trying to convert a timestamp field in Teradata into format 'MMM-YYYY'

or 'Mon-YYYY' in Reportstudio within the data item expression

Regards,
Sony