Questions tagged [date]
A date is a reference to a particular day represented within a calendar system, and consists of year, month and day. Use for questions about creating, manipulating and storing date information. Use with any relevant language tags.
76,985
questions
-3
votes
0
answers
41
views
Exception in thread "main" java.time.format.DateTimeParseException: Text '04-Sep-2023' could not be parsed at index 3 [duplicate]
below is the datetimeformatter
DateTimeFormatter dtf2 = new DateTimeFormatterBuilder().parseCaseInsensitive()
.append(DateTimeFormatter.ofPattern("dd-MMM-yyyy")).toFormatter()...
- 84.5k
0
votes
0
answers
4
views
Getting Error [Microsoft][ODBC SQL Server Driver] String data, right truncation and Dates sorting incorectly
I am accessing a SQL database and pulling data that I will then filter further for a variety of uses. The current version which pulls properly includes a date column showing YYYY-MM-DD and I want it ...
1
vote
1
answer
9k
views
AngularJS and input type = date, how to format model data?
I have following form input which I'm trying to fill by scope data:
<input type="date" name="editCallForm.date" ng-model="editCallForm.date">
I tried a few ...
CommunityBot
- 1
1
vote
2
answers
20k
views
How can I set Date object to null in Javascript?
I am trying to set check_date to null
I tried
new Date as 0, null
but none of them are working for me. How can I achieve this?
Code
async lastDayToLive() {
const allDiner = await this....
- 101
0
votes
0
answers
22
views
Does Date object in browser update timezone correctly after changing system timezone frequently on Ubuntu?
I am encountering an issue where the browser timezone information becomes incorrect after changing the system timezone multiple times on my Ubuntu PC. Specifically, the Date object in my browser ...
- 656k
0
votes
2
answers
482
views
Java get FirstDate and LastDate of following month in MM/dd/yyyy format even if the input is not the first day of the month
I have a function below which has an input Date and it will return the first and last Date of the next month in MM/dd/yyyy format.
String string = "01/01/2022";
DateFormat sdf = new ...
- 18.3k
0
votes
2
answers
49
views
Is there any method to convert a varchar with specific format into time in Oracle SQL?
I have a table with three columns, one of the columns ateststatus_date has the following format: e.g:
28-MAY-24 11.57.20.000000 PM
and it's defined as varchar(2). I used To_date() and ...
- 162k
0
votes
0
answers
8
views
Natural date parser for chat bot
I need a date parser in Node.js to parse or find dates from the user entered queries.
To design a chat bot - in chatbot user will be asking for a data for a particular date,
so the queries can be in ...
7
votes
5
answers
8k
views
Getting previous particular day in a week
I am using java date java.util.Calendar and java.text.SimpleDateFormat for my report page.
I want to always set the start date to previous saturday and end date to friday after that saturday.
I ...
- 2,470
43
votes
27
answers
107k
views
Add business days to date in SQL without loops
I currently have a function in my SQL database that adds a certain amount of business days to a date, e.g. if you enter a date that is a Thursday and add two days, it will return the date of the ...
- 6,744
0
votes
1
answer
35
views
Excel Formula for Today's Month Being Greater Than Lookup Value Month & Provide Message
I have created a budget sheet in Excel to track Debt Snowball payments. I have a formula that successfully works to lookup the month from a list of months (column F) that a final payment is made for a ...
10
votes
8
answers
26k
views
Parse m/d/Y formatted date string into $m, $d, and $y variables
If I've got a date string:
$date = "08/20/2009";
And I want to separate each part of the date:
$m = "08";
$d = "20";
$y = "2009";
How would I do so?
Is there ...
- 46.6k
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:
...
- 1
10
votes
5
answers
36k
views
Time difference and convert into hours and minutes in javascript
I am having the time values as follows
starttime like : 09:00:00 ,
endTime like : 10:00:00 ;
here no date value is needed.
so this values need to calculate difference and convert into hours and ...
- 141
164
votes
14
answers
432k
views
Set date in input type date
I will set today's date in the datepicker input type date in Chrome.
$(document).ready(function() {
let now = new Date();
let today = now.getDate() + '/' + (now.getMonth() + 1) + '/' + ...
- 821