Questions tagged as 'date'

3
answers

How to print JavaScript variable value in HTML tag? [closed]

I would like to limit the selection of input date in this way, but it is not working. <script type="text/javascript"> var data = new Date(); var dia = data.getDate(); var mes = data.getMonth(); var ano4...
asked by 13.10.2017 / 17:40
2
answers

Group By by Date

I have a table named tsc , with the properties ID and DataHoraOcorrencia . I need to query the amount of ID and DataHoraOcorrecia . SQL SELECT DataHoraOcorrencia as DataHora, COUNT(tsc.ID) as Quan...
asked by 10.11.2017 / 14:13
2
answers

Compare dates using LocalDate

I need to do a date comparison as follows: dat_envio_shopping + 2 dias úteis < [data hoje] Until then I have done so: boletoSerasa.getEnvio().isBefore(LocalDate.now()) My question stays in these "+2 business days". How can I make...
asked by 05.09.2018 / 20:35
1
answer

Make the java.sql.Date object have the format dd / MM / yyyy [duplicate]

I have a field that is of type String , where a data is entered in the format dd/MM/yyyy , I'm converting to java.sql.Date , the result is: 2018-01-01. What I needed was to get the date in the format: dd/MM/yyyy...
asked by 18.03.2018 / 17:13
3
answers

Convert String to date and remove 1 day from this String

I have this string: $data_final = "26/11/2017"; And I need this variable to be 25/11/2017 . That is, I need to convert string to date and remove 1 day from that date.     
asked by 21.11.2017 / 11:47
1
answer

Difference between dates in Months, for interval = 12

To find the difference between two dates, you should use the date_diff () . $datetime1 = date_create('2016-10-11'); $datetime2 = date_create('2018-10-11'); $interval = date_diff($datetime1, $datetime2); return $interval->m; // months T...
asked by 22.11.2016 / 19:00
1
answer

I can not keep the format of a date received from a dataframe

I have a dataframe with a date column and another time column: AndIwanttoconcatenatethedatewiththetimetobeinthestringformat"2016-12-25T08:38:00" Initially I was trying this way: datainicial=vpnsessions2[1,3] View(datainicial) horain...
asked by 11.05.2018 / 12:55
2
answers

Parsing a timestamp with timezone

I was making a small code to implement a treatment case in a friend application module and got stuck with a problem. This is a unit test. To put in the application module I would have to make some adjustments when inserting into the native co...
asked by 01.05.2018 / 02:36
1
answer

How to know if two periods intersect?

Let's say I have 2 objects that have the following property: Objeto 1: Date dataAtivacao; Date dataDesativacao; Objeto 2: Date dataAtivacao; Date dataDesativacao; How do you know if these dates "cross". For example: EXEMPLO 1, ENTRADA:...
asked by 30.06.2015 / 05:07
1
answer

SELECT for date format dd / mm / yyyy hh: mm: ss

Inquiry SELECT campo FROM Tabela WHERE data BETWEEN '2016-10-20' AND '2016-10-20' data and a field with type datetime , I'm having problems with records for example that have the following value: 2016-10-20 19:00:00 Da...
asked by 21.10.2016 / 14:03