python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - exasol

how to sum timestamps by 5 minutes

I need help with taking sum of timestamps in sql by 5 mins or since I'm doing analysis so maybe i change it to 6, 7 or 10 mins , particularly in Exasol as it doesn't have all functions like datediff a...
test-img

user12063090

sql

analytics

exasol

Votes: 0

Answers: 1

Latest Answer

Exasol has functions similar to datediff and dateadd: MINUTES_BETWEEN and ADD_MINUTES My solution is based on this SO question: select add_minutes ( trunc (CONTACT_DATE, 'mi'), mod (ex...
test-img

GriGrim

How to find UTF-8 codes via LIKE '%\xC2\xA0%'?

I have a column that contains NO-BREAK SPACE (\xC2\xA0) instead of SPACE and I need to find that rows. Copy-pasting works: SELECT PRODUCT_NAME FROM TABLE t WHERE PRODUCT_NAME LIKE '% %' but using the...
test-img

Vega

unicode

utf-8

codepoint

exasol

Votes: 0

Answers: 2

Latest Answer

Try WHERE regexp_Like(PRODUCT_NAME, UNISTR('\00A0')) Depending on your database character set you may try CHR(106) instead of UNISTR('\00A0') xC2 xA0 is not the code point, it is the binary represen...
test-img

Wernfried Domscheit

Posts

Questions

Blogs

Jobs