Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 20 Apr 2005 @ 17:35:04 GMT

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

Subj:   Re: Problem with Current_date function
From:   Tewksbury, Kevin

We are also about to upgrade to the MP-RAS 3.03 and V2R5.1.2 and I will be curious to see what the GSC has to say.

We have typically always tried to use the following format when manipulating dates (When I say we I mean the DBA's, can't say for sure about the developers):

     Select current_date, current_date - interval '1' day;

I would be interested to see if this works for you.

Kevin R Tewksbury
Database Administrator
Limited Technology Services

  <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