Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 04 Jan 2007 @ 18:03:37 GMT

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

Subj:   Re: Casting integer as Time
From:   Dieter Noeth

Michael Larkins wrote:

  It has been pretty interesting with many of the casting examples that have been posted that CAST casted and formatted data. Why? Is it really necessary to do something the long way? I (like Fred) like a simple approach.  



Now try:

     sel type(cast(213025 as time(0))) as "time";

And now switch off QueryMan's "Allowing Use of ODBC SQL Extensions in Queries" or use BTEQ and try it again :-)


  <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