update row with combination of fields in same row
lazarus / 16-Databases

----------------------------------------------------------------------
ronhud · 2018-09-24 10:42

I have a Firebird database with about 100 tables with identical
structure.  A table has rows which contain a Date column , a Time
column and a Timestamp column.   I want to update the Timestamp by
combining the Date and Time coulmns for that row.    I can find
examples of using two different tables for this but not so far for the
same table.  I thought of a SQLQuery with update and select but I cant
see how to combine these in the one statement .

----------------------------------------------------------------------
ttomas · 2018-09-24 11:04

This is FirebirdSQL question
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i update
table1 set mytimestampfield=mydatefield+mytimefield

----------------------------------------------------------------------
ronhud · 2018-09-24 11:08

thanks so simple!