Archives of the TeradataForum

Message Posted: Thu, 30 Sep 2004 @ 17:08:39 GMT

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

On Thu, 30 Sep 2004 17:14:06 +0200, Victor Sokovin wrote:

If you are just selecting it why don't you just use FORMAT?

On the other hand since SQL Assistant doesn't honor Format statements maybe this won't work everywhere.

     sel Current_timestamp,
      current_timestamp (format 'HH:MI:SS');

      *** Query completed. One row found. 2 columns returned.
      *** Total elapsed time was 1 second.

                 Current TimeStamp(6)  Current TimeStamp(6)
     --------------------------------  --------------------
     2004-09-30 10:18:10.470000+00:00              10:18:10

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