Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: pucklinger
- Order by date
-
converting seconds in time format
Hi Dieter! thanx for your fast help! Works perfekt.... Had not the idea to cast as intervall. Cheers Pucklinger- pucklinger
- Post #3
- Forum: NCR: Teradata
-
converting seconds in time format
Hi, I got a problem: I have a column c1 with seconds stored as integer data type. I want to display time format. e.g. 61 second should be displayed as 00:01:01. I tried severel things, but nothing helped. select time '00:00:00' + interval column1 second from talbe1 doesn't work, because...- pucklinger
- Thread
- Replies: 2
- Forum: NCR: Teradata
