I have generated a table that contains dates from 2000-01-01 to 2039-12-31 (ISO format). Calendar contains leap years. Now based on this I want to create another table with some transformations. I have a problem with two columns. Fiscal_year_day_nr and…
I want to convert a date time field which is in UTC format to IST time format. This is the query which I have. select file_name,Process_start_time,Process_end_time from Process_logs where process_Start_time and process_end_time are in UTC format which I want in…
In SQL I'm looking for a potential function which I can use to apply a row number each time a certain criteria is met. Each time the Unique ID is the same (i.e. same person) and the Dep_Group is WES…
Example 1: Input: Activity table: +------------+------------+---------------+-----------+ | machine_id | process_id | activity_type | timestamp | +------------+------------+---------------+-----------+ | 0 | 0 | start | 0.712 | | 0 | 0 | end | 1.520 | | 0 | 1 | start…
I am working on an SQL problem for a class - "Provide a student/parent list. Formatted child name, parent name 1, parent name 2. If a child doesn’t have a parent, just display null." The expected result should look like…
I'm using Laravel 9 and PHP 8.0. When I try to update a user, I get the following exception: SQLSTATE[22007]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting date and/or time from character string. I think the query…
I have the following data and MySQL table : CREATE TABLE my_tbl( id INT, dataset_query longtext ); INSERT INTO my_tbl(id, dataset_query) VALUES (1, '{"database":1,"native":{"query":"SELECT * FROM view_1.device","template-tags":{}},"type":"native"}'); INSERT INTO my_tbl(id, dataset_query) VALUES (2, '{"database":1,"native":{"query":"SELECT id, name FROM view_1.request","template-tags":{}},"type":"native"}'); INSERT INTO…
I have something like a netflow table and would like to group it in such a way that it groups it by (src_ip, src_port, dst_ip, dst_port) where the values could be swapped between the src and dst fields. src_ip src_port…
I have two tables one mentioning the start and end time of an event and corresponding value and other having the value recorded at midnight daily. CREATE TABLE table1 ( id integer, date_strt timestamp, date_end timestamp, strt_unit integer, end_unit integer…
For a reason that would take too long to explain, I don't have any heading H2 tags in my articles published on my WordPress, but h3, h4, h5, and h6 yes. So I have to modify all the other tags…