Questions tagged as 'data'

Tagged questions
1
answer

Date conversion to oracle

I have a problem, I'm trying to save a date in oracle with the formatted dd/MM/yyyy , however, in the database it displays the date in dd/MM/yy format. So, I came to doubt, if the type I used in the table is not appropriate, or i...
asked by 23.09.2017 / 02:10
2
answers

Date Value 0000-00-00 can not be used in java Date

First of all, yes, I already added ?zeroDateTimeBehavi‌​or=convertToNull in the connection URL, the problem is that in the query the date zeroed does not come null and always releases the following Exception: java.sql.SQLException: Valu...
asked by 11.04.2017 / 14:22
1
answer

Sqlite Filter as error in return date with strftime function

Hello, I have the error in the following code SELECT L.*, C.DESCRICAO AS CATEGORIA , CASE WHEN L.TIPO_LANCAMENTOS = 'C' THEN 0 ELSE 1 END AS ICONE FROM LANCAMENTOS L JOIN CATEGORIAS C ON(C.CODIGO = L.COD_CATEGORIA) WHERE strftime('%m', L.DATA)...
asked by 17.11.2016 / 18:19
1
answer

SOMAR STRING as DATE - Oracle

I have the TEMPO column with type STRING and I need to add the values as hours. I use all sorts of queries to do this sum, but I always fall into the field problem with DATATYPE DATE do not accept values larger than 23:59:59 ....
asked by 09.11.2016 / 05:49
1
answer

JAVA Date Comparison

Good people I have a array of strings with dates, coming from a query with Firebase database. I want to organize it in a growing number of dates. Ex: 05/09/2016 - 09/09/2016 - 11/11/2016 Dates are entered into my array by the pop...
asked by 05.09.2016 / 00:38
1
answer

How to format a date in CDT?

How do I make a date in this Tue, 3 May 2016 12:49:24 -0500 (CDT) format so 03/05/2016 ?     
asked by 04.05.2016 / 09:27
1
answer

Corrections in Fullcalendar

I'm trying to adjust the display position of the content within the first, the one that shows the Month / Day. I would like it to appear as: Day / Month, Ex: 23/08. I searched, but my lack of "ability" with Js is hindering me a little,...
asked by 23.08.2014 / 17:55
1
answer

Read Dates file and count days elapsed in the year

I'm trying to make a program that opens a file and calculates the days elapsed from the date. The dates are in the file as follows: 30-10-2018 . But I'm having trouble with the output that is printing garbage. Follow my code so far....
asked by 30.10.2018 / 20:33
5
answers

How to calculate the difference between two dates?

What is the most practical way to find the time difference between two dates in the standard format used by MySQL (YYYY-MM-DD)? Ex: Date 1: 2013-12-11 Date 2: 1994-04-17     
asked by 11.12.2013 / 17:59
0
answers

datepicker is not a function in typescript

I want to implement datepicker in a typescript project. I tried to initially install the datepicker by npm but I could not ... so I'm trying the standard way anyway. I originally imported <link rel="stylesheet" href="https://stackpath...
asked by 27.10.2018 / 03:24