Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Nov 2006 @ 16:18:02 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Week of the year
 
From:   Vinay Bagare

Use this

     SEL Week_Of_Year
     FROM SYS_Calendar.Calendar
     WHERE Calendar_Date = CURRENT_DATE;

There is no DUAL table in Teradata.

SYS_Calendar database has all the information you will need.

CURRENT_DATE is ANSI equivalent function to get capture current date.

Hope this help.


Thanks,

Vinay Bagare



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023