# | Date | Forum | Type | Thread | Post |
---|---|---|---|---|---|
3 | 31 Jul 2015 @ 02:39 PDT | Tools | Reply | Convert date format m/d/yyyy to mm/dd/yyyy in TPT | select cast( REGEXP_REPLACE( REGEXP_REPLACE( REGEXP_SUBSTR(trim('11/5/2002 12:00:00 PM ....blah'), '^([0-9]{1,2}\/){1,2}[0-9]{4}'), '^([0-9])\/', '0\1/'), &... |
2 | 04 Jan 2010 @ 11:21 PST | Database | Topic | Convert Volatile Table to Permanent Table | Can someone show me the code that you would use to convert a volatile table to a permanent one? |
1 | 11 Dec 2009 @ 11:30 PST | Tools | Topic | SQL Assistant annoyance - how to fix | This issue is really throwing me off. Everytime I click on another query tab, it jumps to the top of the query and does not stay at the position that you were last viewing. This is a real pain when... |