# | Date | Forum | Type | Thread | Post |
13 | 24 Jun 2016 @ 07:08 PDT | Database | Reply | CASE statement in SQL | CASE 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... |
12 | 12 Feb 2016 @ 05:48 PST | Private Forum |
11 | 29 Jul 2014 @ 07:29 PDT | Database | Reply | compression calculations | Try this not sure whether it is useful. Please modify condition as you wish
--*****************************************************************
--** Create Table Co... |
10 | 29 Jul 2014 @ 04:01 PDT | Database | Reply | Thoughts 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... |
9 | 07 Jul 2014 @ 06:24 PDT | Private Forum |
8 | 07 Jul 2014 @ 04:13 PDT | Private Forum |
7 | 23 Jan 2014 @ 07:54 PST | Tools | Reply | new line character | Is 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
|
6 | 17 Dec 2012 @ 05:59 PST | Tools | Reply | How to convert Ordinal (Julian) Date to Calendar Date | I found this formula that works with future dates:
SELECT TRIM ( TO_DATE ( CAST ( 2415020 + CAST ( xxxxxx AS INT ) AS CHAR(7) ) , 'J' ) )
Adel
|
5 | 17 Dec 2012 @ 04:29 PST | Tools | Reply | How to convert Ordinal (Julian) Date to Calendar Date | The 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... |
4 | 17 Dec 2012 @ 03:38 PST | Tools | Reply | How to convert Ordinal (Julian) Date to Calendar Date | Many 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
|
3 | 14 Dec 2012 @ 07:29 PST | Tools | Reply | How to convert Ordinal (Julian) Date to Calendar Date | This 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... |
2 | 14 Dec 2012 @ 06:03 PST | Tools | Reply | How to convert Ordinal (Julian) Date to Calendar Date | I am trying to convert Julian date 47712 into date format. I used the above formula but it only works up to 41199?
Any idea?
|
1 | 15 Feb 2012 @ 07:49 PST | Database | Reply | How to setup and run Higa macros |
Where are Larry Higa macros?
|
|
|