Question : I am working with a JSON document which I receive from an external source. In this document, there […]
Tag: cast
how to get back the modified INOUT parameter in postgres
Question : I have two functions with a similar signature, lets say: CREATE FUNCTION func1(INOUT new “My_Table”) AS $$ … […]
Is TEXT to VARCHAR(MAX) an implicit conversion?
Question : I am copying TEXT columns to another table where the destination column is VARCHAR(MAX). It appears that this […]
COALESCE with cast
Question : I’m pulling data from a jsonb column in Postgres, and casting it to an integer to compare it […]
can I be helped? my querey should = something like .000534 however I get 0
Question : My query result should be 0.000534, but I’m getting 0. Please help me. psql -Upostgres -dcans -c ‘select […]
SQL Server: CONVERT From ISO8601 To DateTime Within Query
Question : I have a Microsoft SQL Server 2008 R2 database where the DateTime column is not a datetime data […]
Error converting NVARCHAR to BIGINT when in SUBQUERY with WHERE clause after invalid records filtered [duplicate]
Question : This question already has answers here: Execution plan flips Filter and Execute Scalar when using the PK, causes […]
Can MariaDB or MySQL cast as bigint, getting an error: … right syntax to use near ‘bigint)’?
Question : If I want to take a string and create a table (this fails in strict mode), CREATE TABLE […]
Casting fraction number to decimal throws Arithmetic overflow error
Question : I have a table called AssignmentMarks that stores Student’s assignment marks for different subjects. This table has a […]
what are the possible reasons for ‘Arithmetic overflow error converting expression to data type int’ in SQL server
Question : When this command is run, there is SQL server error ‘Arithmetic overflow error converting expression to data type […]