Questions tagged as 'data'

Tagged questions
3
answers

SQL largest date of a record before the given date

Next has the following case: Tb_importacao [cod_titulo,data,imp_situacao] cod_titulo data_imp situacao 1 2015-04-10 1 1 2015-04-11 2 1 2015-04-11 1 1 2015-04-13 2 1 20...
asked by 16.04.2015 / 19:26
4
answers

Filter using only month and year in SQLSERVER

I need to mount a select, in which the filter is used only the month and year in the parameters. This is the select I'm currently using, but I need the 'day' not to influence my search. SELECT NOME_CLIENTE, COUNT(NUMERO_BILHETE) AS...
asked by 03.01.2019 / 14:45
1
answer

Calculation of duration with interval

Good morning, I'd like to know that someone can help me create an interface in conjunction with the calculation in PHP between working hours and minutes of pause. That is, we would have an input time entered by the user and an exit time. In a se...
asked by 16.04.2018 / 13:18
1
answer

Error converting string to date, with dateformatter in swift

In the user registry I have an input with a mask in this format "dd / MM / YY", after getting the input value, which comes as string, I have to convert it to date. The conversion always worked, only with the date 10/25/1992 that it's the problem...
asked by 15.02.2018 / 17:17
1
answer

How to change a table indicating that the data of a certain field can only vary from date 1 to date 2?

I have a table called "LOC_VEICULO" where the vehicle data is contained. In it I have the following field: DT_FABRICATION (DATE), where the manufacturing dates of the vehicles are stored. I need to change the vehicles, indicating the dates of...
asked by 10.09.2017 / 05:25
1
answer

Date format configuration in VueJS / Quasar Framework

I have a field for entering the date of birth, and I want the result of the insert to be formatted in 'DD-MM-YYYY'. I was able to make the date appear in the input in the desired formatting, however when I send the date to the database it goes l...
asked by 16.08.2017 / 15:14
2
answers

PHP - How to compare a date that comes from the MySql database with the current day? [duplicate]

I have a column in the database that is in DATE (Y-m-d) format. In the php code I retrieve this string and I have to compare it with the current date and this is the condition I'm using: $dtEntrega=date("Y-m-d",strtotime($row["dtEnter...
asked by 30.05.2016 / 22:45
2
answers

Difference between dates in months javascript [duplicate]

I want to have the difference of months between two dates. But I'm missing something. I want to type the dates in the inputs and the result appears in another input. var DateDiff = { inMonths: function(d1, d2) { var d1Y = d1.getFullYear...
asked by 16.07.2016 / 04:42
1
answer

How to save and retrieve a date field in SQLite3?

The issue is that in the SQLite site itself says that for date fields is to use numeric type or string , fine with numeric I write in the database the date without special characters, however in the string , is there any way to make a sele...
asked by 14.01.2016 / 18:04
1
answer

Date format in PHP coming from SQL server

I'm running the following code: $sql= mssql_query("select getdate()"); $res = mssql_fetch_assoc($sql); and it is returning me the following date:    2015-04-10 32767: 06 The time is 5 digits, does anyone know why? ps. I've alrea...
asked by 02.10.2015 / 14:56