Questions tagged as 'datetime'

Tagged questions
3
answers

Compare dates in Python

Good afternoon!     I need to solve the following scenario in python: I have one or more .txt files in a folder, but I want to return only the files that have the modification date according to the date I want (initial and final), but I'm not ab...
asked by 05.09.2018 / 15:18
2
answers

How to standardize DateTime format for all type fields without using DisplayFor or EditorFor in MVC?

In many cases in the application we have to use something like: @Html.Raw(item.data.ToString("dd/MM/yyyy")) can not be DisplayFor nor EditorFor in any case and we have to show the Brazilian date format. How to standardize this...
asked by 15.09.2016 / 20:50
2
answers

MySQL DATE type is shown as DATETIME in a datagrid

I create a very simple database with the following command: CREATE TABLE IF NOT EXISTS 'ABC'.'Socio' ( 'idSocio' INT NOT NULL, 'SocioNome' VARCHAR(45) NULL, 'SocioDataNasc' DATE NULL, PRIMARY KEY ('idSocio')) ENGINE = InnoD...
asked by 09.11.2016 / 22:31
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

How to get only the date, without the time, of a DateTime?

Converting a field using ToDateTime it brings the date and time. parcelamento.data_vencimento = Convert.ToDateTime(reader["data_vencimento"]); Is there any direct conversion to bring only the date without the time?     
asked by 03.01.2016 / 00:11
1
answer

Comparison of strings (that match the hours) in javascript is reliable? How it works?

It is well known that in terms of time, that 07:30 is less than 08:30 - speaking in hours. In javascript, if we make this comparison, everything goes as expected above '07:30' < '08:00' // true '08:30' > '09:00' // fals...
asked by 24.08.2015 / 19:14
2
answers

Define date and time format used by DateTime

I have an application where it has record time, which uses DateTime.Now , and a start date and end date that the user informs. Showing this data in a DataGrid is in MM/dd/yyyy hh:mm tt format. I want it to be shown in the Bra...
asked by 09.09.2015 / 18:35
2
answers

Extraction of datetime object value in Python.

I need to extract only the time of a datetime object. How to proceed? The object returns the following output: "3 days, 22:01:00"     
asked by 19.10.2017 / 01:49
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

error with EF and Mysql query

I have the following query: var produto = (from a in context.ItensReceita join b in context.Receita on a.t0080_id_receita equals b.t0080_id_receita join c in context.Medicamento on a.t0080_id_receita equals c.t...
asked by 09.02.2017 / 11:15