# | Date | Forum | Type | Thread | Post |
4 | 08 Jul 2010 @ 03:24 PDT | Database | Reply | Date Subtraction | Thanks Carlos!! |
3 | 07 Jul 2010 @ 07:31 PDT | Database | Topic | Date Subtraction | Hi All,
Difference between 2 dates will give us in Days. As I am casting to Interval Month it should give us in MONTHS..
SELECT (DATE '2010-07-06' - DATE '2010-06-26' ) MONTH
Output is : 1
... |
2 | 24 Jun 2010 @ 03:52 PDT | Database | Topic | Show table | Hi All,
Could please let me know from which DBC tables does Show table command fetches the information?
Appreciate your valuable answers!!
|
1 | 04 May 2010 @ 12:13 PDT | Database | Topic | Row_num() performance | SQL using the QUALIFY_ROW_NUMBER() function are always consuming more resources than before the TD 12 upgrade and sometimes taking longer to execute.
Is this known issue? Is there any way to imp... |
|
|