#DateForumTypeThreadPost
331 Jul 2015 @ 02:39 PDTToolsReplyConvert 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/'), &...
204 Jan 2010 @ 11:21 PSTDatabaseTopicConvert Volatile Table to Permanent TableCan someone show me the code that you would use to convert a volatile table to a permanent one?
111 Dec 2009 @ 11:30 PSTToolsTopicSQL Assistant annoyance - how to fixThis 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...