Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 08 Feb 2011 @ 20:34:01 GMT

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

Subj:   Re: Converting TIMESTAMP to DATE
From:   Dempsey, Mike

Some of these comparisons are still true, however others are no longer true.

SQL Assistant has been able to run in a 'batch' mode for some time now. (although it is intended more for someone who wants to submit a query before leaving for the day and have it automatically logoff and shut down, rather than as part of a standard 'batch' script.)

SQL Assistant also now supports basic conditional logic.

Flexibility for Import / Export depends on what you want to do. BTEQ is more flexible in some ways but SQL Assistant is more flexible in others. (eg. BTEQ can not export data to an Access table, or save to an Excel, Html, or PDF file.)

If you want to apply your own formatting [other than what you can control through the options screen] to a specific column in SQL Assistant you will need to cast that column to CHAR in addition to applying a Format clause.

Eg. Select my_timestamp (Format 'yyyymmdd') (Char(8))
Or Select cast(cast(my_timestamp as Format 'yyyymmdd') as Char(8))

Depending whether you want to use Teradata or ANSI SQL.

Mike Dempsey

  <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