 |
 |
Archives of the TeradataForum
Message Posted: Thu, 04 Jan 2007 @ 18:03:37 GMT
| 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. | |
OK.
Great.
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 :-)
Dieter
| |
