#DateForumTypeThreadPost
1324 Jun 2016 @ 07:08 PDTDatabaseReplyCASE statement in SQLCASE Statement: If any WHERE condition is met then it will ignore ELSE. But this is not the case my example   This works fine SELECT         &n...
1212 Feb 2016 @ 05:48 PSTPrivate Forum
1129 Jul 2014 @ 07:29 PDTDatabaseReplycompression calculationsTry this not sure whether it is useful. Please modify condition as you wish     --***************************************************************** --**  Create Table Co...
1029 Jul 2014 @ 04:01 PDTDatabaseReplyThoughts on CPUBusy caclulations.Hi All, I am using DBQLogTbl  SUM ( AMPCPUTime ) per hour in a specific date. The maximum value is 174550.98. We have one node and 9 CPUs. The total available cpu seconds in one hour is 60*6...
907 Jul 2014 @ 06:24 PDTPrivate Forum
807 Jul 2014 @ 04:13 PDTPrivate Forum
723 Jan 2014 @ 07:54 PSTToolsReplynew line characterIs there a way  to replace up to 10 new-line characters in one table column with spaces other than using Oreplace? I tried complex substring to replace up to 4 NL after that it got messy
617 Dec 2012 @ 05:59 PSTToolsReplyHow to convert Ordinal (Julian) Date to Calendar DateI found this formula that works with future dates:   SELECT TRIM ( TO_DATE ( CAST ( 2415020 + CAST ( xxxxxx AS INT ) AS CHAR(7) ) , 'J' ) )    Adel
517 Dec 2012 @ 04:29 PSTToolsReplyHow to convert Ordinal (Julian) Date to Calendar DateThe julian date, 44712, received in the data file was an error. It was corrected later on by the vendor.   The formula I used, was posted earlier, is SELECT CAST ( '1899-12-31' AS D...
417 Dec 2012 @ 03:38 PSTToolsReplyHow to convert Ordinal (Julian) Date to Calendar DateMany thanks Dieter, I never asked for your crystal ball or expect you to waist your time, I just posted a question and you replied to it. Thanks, Adel
314 Dec 2012 @ 07:29 PSTToolsReplyHow to convert Ordinal (Julian) Date to Calendar DateThis number comes from Oracle and we need to convert into TD data. Can you give an example of how to convert this number and define the rules? I had many different methods and formulas that work w...
214 Dec 2012 @ 06:03 PSTToolsReplyHow to convert Ordinal (Julian) Date to Calendar DateI am trying to convert Julian date 47712 into date format. I used the above formula but it only works up to 41199? Any idea?
115 Feb 2012 @ 07:49 PSTDatabaseReplyHow to setup and run Higa macros Where are Larry Higa macros?