#DateForumTypeThreadPost
704 Dec 2013 @ 09:27 PSTDatabaseReplyWhom can help me explain the ‘46.06:18:08’ time.all SQL college's, Thanks for the response, I have changed my procedure to make use of time instead of integer presented as time "lesson learned" THX. And Dieter, you’re right, I'm working fro...
604 Dec 2013 @ 03:19 PSTDatabaseTopicWhom can help me explain the ‘46.06:18:08’ time.Dear SQLers, A small question about time presentation using a integer data type. I juesed INTEGER FORMAT '99:99:99' to show time. below in steps my chalance :-) SELECT CAST( 110025 AS ...
511 Nov 2013 @ 04:19 PSTDatabaseReplyMonitoring stored procedure runtime (loop query four times)Vlad, thanks for the response. It took some time before I could work this case again and I'm made progress but I'm still puzzled. I found out that Teradata (in my case) waits at the end of...
428 Oct 2013 @ 01:52 PDTDatabaseTopicMonitoring stored procedure runtime (loop query four times)Dear colleges, I had got some unexpected behavior from my stored procedure, probably because the lack of experience on my side . But could anyone help me explain. The stored procedure is basi...
301 Aug 2013 @ 09:55 PDTDatabaseReplyDifferent text formating to decimalWe are currently still using V13.10.05.03 so the oTRANSLATE function is not present yet. The fractional part * is often different number of digits. For now I have to find a solution in string mani...
231 Jul 2013 @ 12:55 PDTDatabaseTopicDifferent text formating to decimalWe recently started with a teradata database, before TD we worked mainly with MS-sqlserver and Oracle databases. Now I have a small challenge, so it looked like   We receive often small or m...
115 Jun 2012 @ 07:58 PDTUDAReplyTeraData vs Oracle First of all I’m not a regular forum poster, more or less a newbie so; sorry, for any mistakes. Second my native language is Dutch so English writing is bit “ruff” :-) I&rs...