Tag: sql
-
How to transform a blob field into string lines (varchar) in SQL Firebird?
Hello guys. In some cases we have BLOB fields in the databases for storing texts. There are times when it is important to retrieve line by line from this BLOB that acts as a StringList or Memo. Cool, but how to do? To help, we created a procedure that converts a BLOB of plain text ... -
How to add or remove hours from a SQL Firebird timestamp field
Today we will see a SQL tip, very useful in our day to day. There are cases that we are setting up our query, procedure or trigger and we need to change the value of a timestmp field, more precisely to add or remove hours. the first thing that comes to mind, would be something ...