Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Jun 2001 @ 20:29:18 GMT


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


Subj:   Time vs. Current_Time
 
From:   James Miller

We have recently installed a new box at our customer site(their first one) and those of us on the team do not have a significant background as a DBA or SYSADMIN to answer the question at hand.

The situation is that when we want to use current_time or current_timestamp, the query returns a '***' value. There is no problem using time, date or even current_date. Is there a function/switch that we need to set? We have already changed from ASCII date to Teradata date. Due to our secure environment, we have no connection to GSC, to allow them to investigate the situation.

So any suggestions would be helpful.


Thanks,

James Miller
NCR/Accelerated Solutions, Inc.
Scott AFB, IL.



     
  <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: 27 Dec 2016