DATE FORMAT
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Teradata Tools and Utilities » DATE FORMAT
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.


DATE FORMAT Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
ajai_47
Posted 8/18/2006 7:00:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/18/2008 7:09:46 AM
Posts: 7, Visits: 9

i m trying to retrieve the max value from the field which contains data like FEB2006,MAR2006, etc... From these data i have to select the max value. Can you please help me out with this ASAP.

Regards

Ajai
Post #4931
dnoeth
Posted 8/19/2006 1:36:08 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 3:41:05 AM
Posts: 522, Visits: 264
Hi Ajai,
you can cast that column to a date:

SELECT
MAX(my_col (DATE, FORMAT 'mmmyyyy')) (CHAR(7))
FROM my_tab;

Dieter
Post #4943
ajai_47
Posted 8/21/2006 2:40:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/18/2008 7:09:46 AM
Posts: 7, Visits: 9
hi dieter..

thanks for the reply.. my problem is solved now.. :-)

Regards

Ajai
Post #4946
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


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

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.125. 9 queries. Compression Disabled.