Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 27 Sep 2002 @ 16:00:53 GMT

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

Subj:   Re: CREATE TABLE AS from views
From:   David Wellman


There's a 'default date' parameter within DBSControl. You may find that the date column in your new table is being formatted based on that (I'm not saying that's right, but...).

The other thing you may want to try is issuing the same sql through bteq and queryman (i.e. cli and odbc). When you issue a standard create table command including a date column and do not specify any format statement you get different FORMAT clauses.


Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <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