#DateForumTypeThreadPost
408 Jul 2010 @ 03:24 PDTDatabaseReplyDate SubtractionThanks Carlos!!
307 Jul 2010 @ 07:31 PDTDatabaseTopicDate SubtractionHi 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 ...
224 Jun 2010 @ 03:52 PDTDatabaseTopicShow tableHi All, Could please let me know from which DBC tables does Show table command fetches the information? Appreciate your valuable answers!!
104 May 2010 @ 12:13 PDTDatabaseTopicRow_num() performanceSQL 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...