Archives of the TeradataForum

Message Posted: Mon, 09 Jan 2012 @ 20:15:56 GMT

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

<-- Anonymously Posted: Monday, January 09, 2012 15:06 -->

Hi Folks

     sel cast(logtime as format '99:99:99.99')
     from dbc.logonoff l
     where username='foobar?

     answer 203,407.41

In SQL assistant the o/p is still ?not in the above format .

What is the ODBC setting or soln to make it look as intended

Any Idea??

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