#DateForumTypeThreadPost
815 Oct 2014 @ 07:47 PDTDatabaseTopicUpdate the table with min and max timestampWhat  all are possible ways to get the exact output mentioned below: start and endtime is timestamp fields ... In the final output starttime should take from status A and end time should take ...
702 Oct 2014 @ 10:16 PDTDatabaseTopicMake insertion to the target table quickerWill block compression ='yes' statement will cause the insert statement slower ? While doing insertion i have SET QUERYBAND blockcompression='yes;' FOR SESSION; INSERT INTO TARGE...
614 Dec 2013 @ 06:18 PSTDatabaseTopicNumeric overflow computation errorNumeric overflow computation error Max (col1) = 11478000.0000 select cast (max(col1)*123.000*12300.00 as decimal( 15,5 )) from table1 Also if we do normal select also not working select (1147...
504 Jul 2013 @ 09:01 PDTToolsTopicFast load ErrorI have one column in the table defined as AAA1 decimal(9,2) sample data: 011069125.71 While doing fastload its throwing an error limit exceeded because its more than 9 numbers. My aim is to...
403 Sep 2012 @ 02:13 PDTAnalyticsReplyNeed to calculate days Thanks, I used like below and x0.event_start_date >(add_months(x2.processing_date+1,-26)); its working
331 Aug 2012 @ 08:41 PDTAnalyticsReplyNeed to calculate days Thank you so much. I got it....
231 Aug 2012 @ 07:18 PDTAnalyticsReplyNeed to calculate days 07/01/2010 which is posted above is wrong it's my mistake. And one thing is, the sql you mentioned above the same logic i tried but its looking for 06/31/2012. will the above mentioned SQL w...
131 Aug 2012 @ 04:36 PDTAnalyticsTopicNeed to calculate days Date Table: Table name:control_date cols: Processdate For E.g) Processing date will have 8/30/2012 Query: (Its failed for invalid date) select processdate + (INTERVAL '1'...