I've noticed that there are the following date
functionsdays_betweenmonths_betweenyears_betweenbut there isn't a
weeks_between equivalent. Is this an intentional decision to omit this
functionality? I'm having to resort to a personal implementation t...
Hi, I'm seeing some slightly odd behaviour when casting to decimal.
Please see the below example. Why is it that if we provide an explicit
figure it rounds and then truncates whereas if we provide and expression
it decides to simply truncate? select ...
Please! Please! Please! can someone enlighten me as to how to call these
2 wrapper functions from the dbVisualizer script window? for data in
wrapper:query_rows( 'SELECT * FROM CAT' ) do output( data.TABLE_NAME ..
data ) end for table_name, table_...
Hi, I'm a beginner with regards to Exasol scripting with Lua. I've been
through the course material for fundamentals and database development,
but am struggling with one aspect. That is the use of query results with
Lua. Once I have this aspect unloc...
Hi, I was wondering if I could get some help with string manipulation.
If i'm provided with the following example Create a function
add_prefix(arr, prefix) that takes an array of strings arr and a string
prefix as an input. It should output a comma-s...
I've just found these resources that mention a slight issue with DOUBLE
I just read this on the following doc link
Data TypesExasol supports approximately and exact numerical data types.
The difference when using the approximate data types aris...
I was after the result '99.1' after it having been rounded up to 1
decimal place. Key is to use the explicit round function before
casting.create or replace view my_schema.DataTypes as select
cast(5943.00/cast(60.00 as decimal(10,2)) as decimal(10,2)...
Thanks for your input, it really helped demystify what's happening
behind the scenes. It looks to be the divisor operator is returning
double return value...There is no way to retain that behaviour of round
then truncate when using decimal values in ...