Most voted "datetime" questions
A Datetime object in many programming languages describes a date and an hour of the day. It can express either an instant in time or a position on a calendar, depending on the context in which it is used and the specific application. This tag can be used for any question related to date and time.
Learn more…440 questions
Sort by count of
-
0
votes1
answer41
viewsWhy when creating a zoo series object the columns change from Numeric or integer to Character?
Good evening!!! I am confused enough. I will explain the pass-by-step until I get to the doubts that I finally could not solve: My goal is to create a file where tickers quotes are stored where each…
-
0
votes1
answer54
viewsORACLE displaying date field with 1 more day at the end of the months with 31 days
I created a function in ORACLE to calculate the date of the last installment by passing as parameter the number of installments and using the function ADD_MONTHS(DT_PRIM_PARCELA, INSTALLMENTS).…
-
0
votes1
answer39
viewsgroup each period per month
I’m doing this consultation, but I’m not able to group each period per month, the previous year. For each month of the year preceding the current year, return the amount of parked cars per period…
-
0
votes0
answers37
viewsUse only hours, minutes and seconds on a graph
I’m trying to use the time variables (hour, minute and second) that are organized in columns to make a graph. In addition I have information every 1 second and I need it every 1 minute so I cut the…
-
0
votes0
answers74
viewsHow to format a date in Brazilian Javascript format?
How do I format a date for the Brazilian standard in Javascript? I looked in several places but I could not get the date to be displayed in the Brazilian standard. Summary of the problem: How the…
-
0
votes1
answer54
viewsSyntax Error (Phyton)
I am doing a work here with python using Pandas/Matplotlib/Seaborn/Numpy and wanted to understand why it gave syntax error. I’m trying to modify 3 columns of my dataset if String for Date Time.…
-
0
votes1
answer22
viewsC# Month Combobox - Setting Selecteditem
I have to create a Combobox only with the months of the year to handle the system’s paying bills. So far so good, the problem is that the client wanted to be selected the current month in Load. I…
-
0
votes1
answer27
viewsRemove an hour with minutes or not from a date
I have the following code: <?php //batidas do controle de ponto de um x colaborador $d1 = new DateTime('2021-08-06 12:00:00'); $d2 = new DateTime('2021-08-06 15:00:00'); $d3 = new…
-
0
votes2
answers97
viewsCheck if time interval is within another range
I need to know if it was worked within a fixed interval $entrada_padrao = strtotime('08:00');//fixo como parametro $saida_padrao = strtotime('18:00');//fixo como parametro $entrada_trabalho =…
-
0
votes0
answers7
viewsChange the start and end date reference of a month in Power BI
I need to create filters in Power BI Dashboard in which the month of August, for example, starts on the 20th of July (previous month) and ends on the 19th of August. This should be done for all…
-
-1
votes2
answers919
viewsSeparate time and search between dd/mm/yyyy dates
I have a contract table called contract two-column data_ini and data_fim. data_ini and data_fim are as follows: 20/04/2014 10:46 I need to do a search between dates, without the time. If I didn’t…
-
-1
votes1
answer458
viewsDifference of dates with Legend in a Textfield
I am developing a hotel system and would like to automate some features in the system. I would like that when you select two dates being the dataEntrada and dataSaida using Calendar, make that when…
-
-1
votes3
answers4858
viewsHow to write a date in ISO 8601 type
I’m doing a communication program with Apis online and I’m using a header like DateTime and I needed that date to stay on the ISO 8601 how can I do this ? I’m using this to create the header : var…
-
-1
votes1
answer552
viewsHow to take time from one field and add up to 3 minutes in another?
I’d like to know how to get to the time of the field txt_hora and move on to the txt_hora2 adding up +3 minutes. In case on the field one would be 09:50 and move on to the other 9:53. Here I enter…
-
-1
votes1
answer1763
viewsCalculate SQL mean with time field
Good morning Everyone, I’m having trouble solving the select below. I have the select below that returns me the amount of hours of a given event and by the return visa in varchar. What I’m having…
-
-1
votes1
answer49
viewsError obtaining time with Row.getCell()
I’m getting data from a spreadsheet in excel. public void Hora() Cell horaAgen = null; if(row.getCell(7) != null ){ horaAgen = row.getCell(7); System.out.println("hora: "+horaAgen); } } On the…
-
-1
votes1
answer120
viewsGet month value from a list
I need the person to be able to get the information and month they want, so I need to get this information from the list and then show the license plate, date, time of entry and exit, paid amount…
-
-1
votes1
answer379
viewsI want to convert Timedelta to float
I have a Dataframe in which one of the columns is the time interval in days between the search from one row to another, the data of this column are in the Timedelta form, as in the example:…
-
-1
votes3
answers299
viewsHow to make Visual Studio interpret an hour that is larger than 23hrs and smaller than 6hrs at the same time?
I have a function that is called and must enter the condition where the time now is greater than 23 hours and less than 6 hours at the same time, however the code conflicts with this condition and…
-
-1
votes1
answer186
viewsInclude hour with minute in a javascript hour array
I have a method that generates an array of number time and string time, one to show in the table and one to send in the json. The point is I’d like to include 01:00 / 01:30 - 02:00 so on. function…
-
-1
votes1
answer294
viewsDate +1 Month increment (considering days, month and year)
Here’s the thing, in a system I’m developing, I need to increment a date. Below follows the code that I managed to develop until the moment that this works perfectly for increment even considering…
-
-1
votes1
answer132
viewsDatetime.Parse returning wrong time
Hi, I’m doing this: DateTime horaInicio = DateTime.parse(parsedJson['comeco']); Value of parsedJson: As you can see in parsedJson it’s 7:38:33 and this is the time I wanted, but I have as an answer:…
-
-1
votes1
answer120
viewsHow can I add up times told by the user?
from datetime import datetime inicio = input( 'Informe o horario de inicio do experimento (formato Horas:Minutos:Segundos): ') termino = input( 'Quanto tempo durara o experimento (formato…
-
-1
votes1
answer243
viewsNameerror: name is not defined for initialized vector, how to tidy?
I’m making a program to calculate a certain time, with a probability of something happening and going wrong, but I’m getting Nameerror: name 'tempo_ida' is not defined variable h is defined as 0.…
-
-1
votes1
answer99
viewsPandas convert epoch str to datetime
Good afternoon, everyone. I need help converting types in pandas. Follow the information: I have CSV containing the Intel, a Bulletin field, ctime, mtime and the name of the files respectively,…
-
-1
votes0
answers17
viewsHow to set a (future) test-only date during a debug? (visual studio)
I have to test the system with some special dates. I currently do this manually, IE, where there is a "Datetime.Now" put a breakpoint and Seto the date I want. Another way is by changing the windows…
-
-1
votes0
answers26
viewsDatetime does not recognize strftime
I’m trying to make a code that receives a date in the format of String, this way '2021-8-24', year month day, but I will convert to date, only the terminal speaks: data_converted =…
-
-2
votes2
answers362
viewsDate_format does not work in code
After following several instructions and operating guides of Date_format, I preferred to ask for help as I tried everything and could not format the date and time output of the Mysql database. Does…
-
-2
votes1
answer35
viewsHow to turn Y-m-d to Unix midnight timestamp into PHP?
Good afternoon, I need to convert the data from a form that comes in the format ex: 2018-02-13 for UNIX at midnight. If I convert normally using strtotime it comes right but with the time of 6:00AM.…
-
-2
votes2
answers1455
viewsError in Datetime.Tryparse
I have a problem with a conversion using the code below: string vcto = "29/01/2018"; DateTime data; Boolean resp = DateTime.TryParse(vcto, out data); if (resp == false) { MessageBox.Show("ERRO NA…
-
-2
votes2
answers1074
viewsGenerate random time within a range
I have a function that generates the current time, time +12hs and time +24hs. I need him to run a random schedule within that 12-hour and 24-hour window. I got the following: //DEFINE HORARIO DE…
-
-2
votes1
answer92
viewsCalculate birthday date in typescritp
I’m developing a freelance system for a college job and I’m having trouble calculating date. I have a date field (for date selection) and another blocked label that will bring the result (age )…
-
-2
votes1
answer168
viewsType Object 'datetime.datetime' has no attribute 'datetime'
I have a view that matters some functions of a model, and when I import the model within the view, I have a problem with datetime. The function that exists in the model works perfectly, but in the…
-
-3
votes3
answers522
viewsHow to put variables in datetime (PHP)
Hello. I wonder if I can put variables in the values of datetime. Example: new Datetime('$ano-$mes-$dia'); If yes, how?
-
-3
votes3
answers898
viewsValidation and counting of days of a date
Consider an informed date in a form. Construct a function that checks if the date is correct (considering leap year, April 31, etc.). You need to pass the date entered in the form as a parameter. If…
-
-3
votes1
answer356
viewsScroll between two dates
I have two dates in milliseconds. I need to recover every day of that period to make an insert in the database. I thought I’d do one for each day of that period, but I have no idea how to do it!…
-
-3
votes1
answer30
viewsUndefined Property: Dateperiod::$format
I am making a system that registers a set of dates via $_POST. I want to insert in the database the range created below via datetime. But when executing appears the above message. How to proceed?…
-
-3
votes2
answers58
viewsData conversion in SQL server after using in Where clause?
I need to extract sales from such a date period until such date. For example, between 01/04/2011 and 30/04/2011. I am not able to bring the result of the period in question. In this case, I am using…
-
-4
votes1
answer159
viewsWhat is the format of this hour?
What is the date and time format in PHP 7.2? 2019-05-13T10:00:00.000Z For example, the time date 2019-01-01 10:00:00 has the format Y-m-d H:i:s.…
-
-4
votes1
answer48
viewsError of isinstance() types
I have a function that receives a date of birth and another reference date to calculate the age of an individual in reference date. It should return me a list containing how many days, months and…