#DateForumTypeThreadPost
923 Jul 2015 @ 08:33 PDTGeneralReplyQuerying the data between 2014 and current dateI didnt understand whats the error excately but i think you can use:... where CAST(the_date AS DATE) between '2013-12-31' and CURRENT_DATE   Note: current_time gives the wh...
822 Jul 2015 @ 02:42 PDTGeneralReplyHow I filter special Chars(*&^%...) in the WHERE clause, i want to pick just Alphanumeric.thanks Carlos, i used otranslate to filter columns contain special chars: sel columnY from table WHERE  LENGTH(OTRANSLATE(columnY, '+~`!@#$%^&*()[]_- ={{}}|\:;"<,>.?/'...
721 Jul 2015 @ 08:43 PDTGeneralReplyHow I filter special Chars(*&^%...) in the WHERE clause, i want to pick just Alphanumeric.thanks CarlosAL OTRANSLATE() works fine ! OTRANSLATE(COLUMN, '+~`!@#$%^&*()[]_- ={{}}|\:;"<,>.?/','')  Note: but i think i am missing ' because i cannot pu...
620 Jul 2015 @ 09:13 PDTGeneralTopicHow I filter special Chars(*&^%...) in the WHERE clause, i want to pick just Alphanumeric.Hi guys! like the title is saying, i want to pull just the alphanumeric data from a column i tried : select * from tableX where columnY NOT LIKE '%[^a-Z0-9]%' but it's not workin...
527 Jan 2015 @ 04:36 PSTGeneralReplySubstring/Trimi got it TDs : SUBSTR(col1, INDEX(col1, ']') +1,(INDEX(col1, 'Add') -1) - INDEX(col1, ']') )   Many tahnks C B
427 Jan 2015 @ 09:57 PSTGeneralReplySubstring/Trim i can trim the first part till ] with : SUBSTR(col1,INDEX (col1,']')+1) which it gives 'Ipad Mini on line' but i cannot cut the last part 'on line' of the column.
327 Jan 2015 @ 08:18 PSTGeneralTopicSubstring/TrimHi Leaders, I got confused how i use substring and trim to get some data, here an example: Col1                             &...
209 Dec 2014 @ 07:48 PSTGeneralReplyOUTER JOIN WHERE IS NULL vs MINUS vs NOT EXISTSOne sentence says everything, @dnoeth Thanks a ton! You're the best.
108 Dec 2014 @ 04:02 PSTGeneralTopicOUTER JOIN WHERE IS NULL vs MINUS vs NOT EXISTSHey, I am trying to get the rows from table which do not exist in the second table in a period of time,  OUTER JOIN WHERE IS NULL is not given me the same result of MINUS ! and the output is ...