#DateForumTypeThreadPost
226 Mar 2014 @ 12:21 PDTDatabaseReplyhow to know the % table size growth/reduce in teradataHi Deepak, I am unsure about the tablespace_hst option mentioned above, but the following query should give you some direction towards the entire approach: select databasename ,tablena...
125 Mar 2014 @ 02:35 PDTDatabaseReplyADD_MONTHS vs INTERVALAnkitIsLucky - Try the code below. select add_months(date '2014-02-28' + 1, -6) - 1 The idea is to use the 1st of the month as the reference for calculating the month backwards. The prob...