All Questions
9,302
questions
0
votes
1
answer
56
views
Query between two dates gives incorrect results in SQL Server? [closed]
Im trying:
SELECT *
FROM database a
WHERE Applicant_End_date >= '2024-01-01'
AND Applicant_Start_date <= '2024-06-30';
Results:
Applicant_End_date shows results starting at 2024-01-01 like:
...
0
votes
0
answers
13
views
Can't seem to get the date parameter to work
The following query works when I don’t add the last AND statement with the dates. However, when I add it, no results are found. I know this isn’t true because I populate data into the engine and know ...
0
votes
2
answers
63
views
JS skips 2023-10-29 when generating data range
I am trying to generate a sequence of dates. However, when generating JS, it constantly misses October 29, 2023. Could someone explain what could be the reason?
In this post someone noted that on this ...
0
votes
1
answer
45
views
How can I modify this script to select any folders dated in the last 12 months?
I have a folder directory (shown below) that contains folders titled "year-month." They will be continuously added over time. I am trying to write a python code that selects any files in ...
0
votes
1
answer
25
views
HIVE SQL script to set end date to 12-31 of current year
I need help with a query that when criteria is met to update an end date to 12-31 of the current year.
In addition, the format would need to be: 'yyyy-MM-dd HH:mm:ss'
I would like to automate this as ...
0
votes
0
answers
25
views
Pandas: In data frame column how to change date time format from '2022-10-11 15:15:00+05:30' to '11-10-2022 15:15'(DD-MM-YYYY HH:MI) [duplicate]
I have a CSV file containing column called datetime with values like 2022-10-11 15:15:00+05:30 in 15 minutes interval.
File has 40k rows and I want to remove +05:30 from all datetime column values.
I ...
0
votes
0
answers
7
views
input type date focus color change
How to change the input type date focus default color blue to some other color. The default focus color is coming blue. how to change the mm selected default blue color. The default blue color coming ...
1
vote
1
answer
22
views
Datetime strptime in python (hours are not showing)
I have date format:
train_time = [01/01/2021 00:00
01/01/2021 01:00
01/01/2021 02:00
01/01/2021 03:00
01/01/2021 04:00
01/01/2021 05:00
01/01/2021 06:00
01/01/2021 07:00
01/01/2021 08:00
I used this #...
1
vote
1
answer
132
views
Angular 17 shows time behind by several hours when using datetime-local
The date-time field is shown using this code below. I chose the correct date and time which is 07/06/2024 11:43 AM when submitting the form:
<input type="datetime-local" [(ngModel)]="...
2
votes
0
answers
41
views
PHP DateTime class returns wrong previous or next month on 31.05.2024 [duplicate]
I am developing a WordPress plugin called WP Date and Time Shortcode which counts to the PHP DateTime and DateTimeZone classes to display previous, current or next date and time based on some ...
1
vote
1
answer
52
views
Read Date from excel and insert into PostgreSQL
I have problem while reading date from Excel file using Apache Poi.
I use the following:
FileInputStream inputStream = new FileInputStream(excelFilePath);
Workbook workbook = new XSSFWorkbook(...
1
vote
1
answer
37
views
How to restrict user to not be able to pick ranged date on restricted daterange picker using syncfusion in flutter
so I am trying to make a date range picker using the syncfusion package in flutter where I want to make the user to not be able to pick at a certain dates which I did able to do, but the range picker ...
0
votes
0
answers
135
views
Google Looker Studio - how to make a time series stacked column chart?
My chart doesn't show all the data from the BigQuery view that was connected to the report.
Here is an example:
I ask to show me the sum of clicks by date for the last 30 days (Apr 7 to May 6). But ...
0
votes
1
answer
86
views
How to order date and time in BigQuery
I'm working with a dataset that runs from July 1, 2021 to May 31, 2022. I converted the original Excel spreadsheet into a CSV file, but when I run queries and try to ORDER BY date my output starts on ...
0
votes
2
answers
76
views
JavaScript Date object showing incorrect date when set to midnight in UTC
I'm encountering an issue with the JavaScript Date object where it's showing an incorrect date when I set it to midnight in UTC. Here's my code:
function updateDates(startDate) {
var utcStartDate =...