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

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

convert timestamp field in Teradata into...

Rate Topic

Display Mode

Topic Options

Author

Message

sony

Posted 10/5/2007 12:59:37 PM

Forum Newbie

Group: Forum Members
Last Login: 10/10/2007 1:54:00 AM
Posts: 7, Visits: 1

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

Post #9146

Shaw

Posted 10/5/2007 1:27:37 PM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 1:34:04 PM
Posts: 117, Visits: 238

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));

Shaw

Post #9147

sony

Posted 10/5/2007 2:19:19 PM

Forum Newbie

Group: Forum Members
Last Login: 10/10/2007 1:54:00 AM
Posts: 7, Visits: 1

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

Many Thanks,
Sony

Post #9148

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 8 ( 8 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 2:00am