Questions tagged as 'date'

Tagged questions
1
answer

How does a column of dates compare to a specific date?

In this image on the left side are the tables that give me, on the side right is what he asks me to do and below in blue is the code that I made in MySQL database language do not know what statement should be used to be able to select...
asked by 17.08.2018 / 06:23
1
answer

Create conditional comparing current date with registration date

I need help with conditionals using dates .. I need when creating a record the cell of the table is colored verde , By passing 3 days after the record was created, the cell is automatically naranja and when going...
asked by 11.08.2018 / 19:54
1
answer

update two input dates automatically?

I need to realize that when creating 2 input, when you select the date of the first, the second can not be selected from the date before. this is how little I have <table> <tr> <th>Fecha...
asked by 26.07.2018 / 21:22
1
answer

"echo" the date if it is different from the previous one

The whole problem is for a chat. I have a echo , within a foreach , and for each message, get the complete date: Example: Sat, 21 of July 2018 and I want to know how to put a check to see if the following message has the sa...
asked by 22.07.2018 / 00:50
1
answer

How to format a date and place decimal points in Oracle?

I have a query which gets Date fields and fields type number The result of this query is placed in an excel file and what it does is that it does NOT show the date fields in DD / MM / YYYY format and it does not show the number type fields wi...
asked by 24.07.2018 / 21:00
0
answers

Store Date with Spring MVC and MySQL

I have the attribute type Date in a class and when I want to register it in MySQL with type date , I get an error and it may be due to the format of the date, but I do not know what to do. Class attribute:    private...
asked by 26.06.2018 / 03:06
1
answer

Detect date change using datetime

I'm looking for a way to make an "Automatic Money Adder"; for example; I get up one day, I turn on the pc and automatically add $ 10 to a file. My problem is part of a code to determine that today is not the same as yesterday and do not add it...
asked by 24.06.2018 / 07:24
0
answers

How to get the current Date in a datetimepicker?

What I want to do is that when entering my page, my two default date fields show the current date, these are my fields <div class="form-group"> <div class="input-group date" id="datetimepicker1"> <input id="fechInicio...
asked by 20.06.2018 / 05:44
0
answers

Illegal hour value '58' for java.sql.Time type in value

I have a doubt with this problem apparently when doing the select and doing the operation with the method TIMESTAMPDIFF of MySQL I get the following error: java.sql.SQLException: java.sql.SQLException: Illegal hour value '58'...
asked by 04.05.2018 / 10:18
0
answers

The first else is always executed if PHP spent a while

I'm doing some verifications for a telegram bot that I'm testing, always the first "else if" is executed when it should not be, for example: I have a client whose payday is the 24th of this month, then, five days before the bot sends you a warni...
asked by 19.03.2018 / 07:52