Asksearch_php.cn

Community Learn Tools Library Leisure

English

Popular searches：
PHP
MySQL
jquery
HTML
CSS

SQL: Calculate if an ID that has only appeared in the last week has not appeared

I'm trying to do a weekly scroll to see if a user did or didn't attend an event. However, I only want to list them as "not attending" if they attended last week. For example, if a user participated in weeks 1 and 7, they will only be counted as "not participating" in weeks 2 and ...

P粉529581199 2023-09-07 11:58:57

Hive query: Convert date timestamp to date format

I want to convert a date timestamp column containing something like '4/12/202315:37' to a date format like: 2023-12-04, using Hive query. Using the to_date format just returns me null values.

P粉504920992 2023-08-14 13:02:24

"Date picker reset on Livewire update"

I have a very simple Livewire component that contains a text field and a date picker: <div><inputtype="text"wire:model="test"placeholder= "test"><inputdatepicker=""wire

P粉696146205 2023-08-25 21:12:55

MYSQL get maximum value from a specific date

I have years of temperature measurement data. Find the highest temperature measurement including dates recorded from the current year only. Try this: SELECTtimestamp,temperatureASmax_tempFROMtableWHEREtemperature=(SELECTmax(temperature)FROMtableW

P粉824889650 2023-07-23 17:50:20

SQLAlchemy: Get the maximum value of grouped values

I have this table in my Flask app: classEvents(db.Model):id=db.Column(db.Integer,primary_key=True,autoincrement=True)timestamp_event=db.Column(db.DateTime,nullable=False) I need to get the day with the most records, including the value and the date itself in a printable format (e.g. d/m/y). I tried ...

P粉738346380 2023-09-01 12:07:40

Get records of employees who took 11 consecutive days off

I have an attendance record with fields for employee number, status and attendance date. I want to use SQL query to get those records of employees who have taken leave for 11 consecutive days. The condition is that if the employee's attendance status is leave, absence or unmarked attendance (a date ...

P粉014218124 2023-08-16 20:44:15

Calculate column date values: Use variables and other columns to perform date offset calculations

I have a project management table with 1000 tasks/records, each task/record has a dynamic starting_date and ending_date column. The values of these dates are obtained by obtaining a static project "online" date (for example, 2022-10-01), and then subtracting the task_offset_days value of...

P粉401901266 2023-09-07 16:31:02

Query the data of a specified date in a specified table in mysql database? There are details

{Code...} The above is the existing query statement, which can find all the tables in the entire database and how much data is in the table. Now I want to break it down: For example, there are 1,000 tables in the test database, and I only want to check 200 of them (specified) that contain the specif...

PHP中文网 2017-05-18 10:49:37

Find users who visit only one city instead of multiple cities in MySQL [duplicate]

I have a table with user ID, city and booking date. I need to find out which users visited only one city within a date range, not multiple cities. SELECT user_id, city, COUNT(*) as result FROM visits WHERE start_ts >= 1675209600 -- 1675209600=01.02.2023 00:00 AND end_ts <= 1675295999 -

P粉764785924 2023-07-24 22:47:07

Date format in HTML form should be "mm/yy"

I want to create an HTML page containing a form where one of the cells should be a date in the format 'mm/yy' with the minimum value being the current month (similar to a credit card expiration date). What should I do? I didn't find an option to use a date/month type, is there a better option than u...

P粉990008428 2023-09-01 11:00:27

mysql - How does a postgreSQL database set the default collation of a table's fields?

I now create a new table with a date field. When all rows of data are displayed, the sorting rules can be changed through the sort filter button settings, but when I close the window and reopen it, the display is messed up again. How to solve it?

怪我咯 2017-05-17 10:01:37

How to find JSON data based on other content in a JSON object when duplicates exist?

I'm currently implementing some data charts on a website, and I have a JSON that contains some data, specifically some ID numbers, some dates, and some data points. Because I have multiple dates under the same ID, I'm looking for a way to do essentially "find a JSON object with this ID and mont...

P粉713846879 2024-04-04 10:57:45

WHERE columnName IS NULL but not getting expected result

I've just started my first project on my portfolio and I'm totally stumped... During the EDA process I noticed that the Continent column with NULL values is perfect for queries specifically targeting continents because of the corresponding population Column has total population regardless of date....

P粉509383150 2023-09-13 00:06:33

Error when submitting form with two date fields and using date_diff() in PHP

Hi everyone, I am submitting a form with two fields "time_in" and "time_out" I am trying to get the difference between two dates using date_diff() I have made sure that the time_in in the database is in DATE formant and time_outDATE format and both Neither are strings I get this ...

P粉817354783 2023-09-13 23:39:55

How to convert a string containing date to mysql timestamp format?

I'm working in a python environment. I have a date string like this - 26Apr202217:23:17GMT I want to insert this date into mysql where the date column data type is timestamp. How can I achieve this goal? Myvariablesarelikethis(id=1,name="Jack",date="26Apr202217:23:17GMT")mycurser...

P粉925239921 2024-03-21 21:09:02

How to format a date with time zone offset using ISO 8601 in JavaScript?

Goal: Find the local time and UTC time offset and then construct the URL in the following format. Example URL: /Actions/Sleep?duration=2002-10-10T12:00:00−05:00This format is based on W3C recommendations. The documentation says: For example, 2002-10-10T12:00:00−05:00 (noon on October 10, 2002, Centr...

P粉054616867 2024-03-25 15:40:11

Executing cypress multiple times and saving the results in different screenshot folders in Cypress version 12.10.0: Fix issue

I'm trying to create a folder to save the screenshots captured from Cypress in a custom folder within the screenshots, where in the ScreenshotFolder folder a file with the date will be dynamically added for each execution of run.cypress() folder but it doesn't work. The problem is that when the code...

P粉201448898 2024-03-29 16:41:20

MySQL SELECT with GROUP BY one field and ORDER BY another field

Edit 3 - MySQL version is 8.0.33. EDIT 2 - See the final working code at the bottom. Thanks @Akina! I have a score sheet for a sporting event. This table has three related fields that I want to select - scoreID as the primary key value classifierID maps to the primary key of another table that conta...

P粉715274052 2023-09-10 17:25:20

Design a database table structure that meets the following business requirements?

I was stumped by the last question in today's interview: (original picture) Design a database table structure that meets the following business needs: 1. A certain merchant holds a lottery for playing games for a period of time. Only users who play the game with 50 points or more can win the lottery...

phpcn_u36412 2018-03-14 23:00:16

Compare values in duplicate tables

I have a query that generates a table of duplicate records from a larger data set, and I would like to be able to perform further analysis on this output data. Here's an example of what you can use. I would like to be able to identify, for each property, instances where the property's oldest rating ...

P粉811329034 2023-09-13 08:52:32