Questions tagged as 'data'

Tagged questions
1
answer

Return greater value of a SQL-specific record

I need my SQL to return the largest date, but not the longest date among all records, and yes, the longest date of a specific id. I've tried to use MAX() , but it returns the highest value of all of the table, as well as a ORDER BY...
asked by 12.07.2016 / 16:30
4
answers

Calculate age in years using javascript

How to calculate age from an input type="text" using javascript? I have the input: <input style="width: 100%" type="text" readonly id="data_nascimento"/> How to do this calculation? The date format is "01/01/2015." Do I need to con...
asked by 21.10.2015 / 19:03
3
answers

Return amount of days to end of year

How could I do to return the amount of days to the end of the year, relying on today. import java.time.LocalDate; import java.time.Month; import java.time.Period; import java.time.format.DateTimeFormatter; public class TestLocalDate { pu...
asked by 28.08.2016 / 21:26
1
answer

Calendar.MONTH returns incorrect month

I'm developing a method where I can get the date, month, and year to create a security key to connect to the server. But I have already verified the date of my emulator and my cell phone is correct, but the month comes with the previous month....
asked by 21.10.2016 / 23:56
3
answers

How to calculate difference of dates that are a previous row with MYSQL?

I have a table where I record the time when a given request had its status_id changed. This table I call historico_status_solicitacoes . In this table, I have the following fields: id , status_id , solicitacao_id...
asked by 01.11.2018 / 21:09
2
answers

Formatting date field with jQuery Masked Input [closed]

Dear, I have searched and tested in a number of ways how to format a date field in jQuery but it is not working. I have already imported the jQuery Masked Input into the JSP: src='<%=renderResponse.encodeURL(renderRequest.getContextPat...
asked by 14.01.2015 / 12:23
5
answers

Capturing dates of a text using regular expression in javascript

I have a function that returns data in JSON and places it in certain places with jQuery. One of these data is text that contains a date range (Start and End). Example of returned text: ESPÍRITO SANTO - Status: This is how much the Brazi...
asked by 11.03.2014 / 19:15
2
answers

Time difference between dates in JavaScript and MySQL

I have data_inicio and data_fim and want to know the difference of hours and minutes between them. The data_inicio will already be saved in the MySQL database as datetime , data_fim will pick the date when the u...
asked by 28.11.2016 / 14:10
1
answer

How to configure Postgres to accept date in PT-BR format?

Situation Let's say I have a form on which the user fills a date field, DD-MM-YYYY. Question How can I make postgres accept this format normally? No need to to_timestamp('14/06/2016', 'DD-MM-YYYY') Addendum SELECT...
asked by 14.06.2016 / 20:32
1
answer

How do I calculate with 3 variables of type DateTime?

I have these 4 variables: public System.DateTime TempoOtimista { get; set; } public System.DateTime TempoProvavel { get; set; } public System.DateTime TempoPessimista { get; set; } public System.DateTime TempoRevisado { get; set; } TempoRevis...
asked by 14.10.2015 / 03:21