It seems like you're actually asking how to remove the time component from a timestamp type.
Let's set up some test data:
CREATE TABLE public.test (
time_stamp timestamp
);
INSERT INTO public.test (time_stamp) VALUES (SYSDATE());
INSERT INTO public.test (time_stamp) VALUES (SYSDATE());
INS...
I am proposing a tag to be named "subtype-table-design". This would collect questions relating to this aspect of database design. Questions about how to design a type-subtype situation come up from time to time. A lot of new database designers have never seen any examples of how this is done, ...
Since you want to use PIVOT to get the result and you need to to this dynamically, I would always suggest writing a static PIVOT query first, this allows you to get the syntax correct before trying to convert it to dynamic SQL.
The desired output shows that you want to PIVOT on two columns, Room...
Sorry in advance if the question makes little sense.
I need to know how to update a table every X seconds/minutes/hours.
I normally do something like this:
UPDATE myTable SET someField = someField WHERE id_ofMyTable > 0 and id_ofMyTable < 1000
After this query, some XMLs files are created thank...
A couple of months ago, I suggested a set of badges for asking questions. The responses were... mixed. The top answer can be summarized:
In practice, all this would do is encourage people to ask yet more stupid, worthless questions and we have quite enough of that as it is.
We believe that ...
The description of the new Curious badge currently reads:
Asked a good question on 5 separate days, and maintains a positive question record.
The term "good question" seems to be defined by the badge Good Question:
Question score of 25 or more.
Curious seems to use another criterion, ...
