Questions tagged as 'datetime'

Tagged questions
1
answer

Filtering by dates SQLite C #

I have a table in SQLite with several fields including a Text type date with the following format: "2018-11-04 12:13:00" Since SQLite does not have the Date field in problems to make queries of dates greater or lesser than one that happens...
asked by 04.11.2018 / 18:13
2
answers

Check days from the 1st to the 5th of each month

I comment, I need the system on the days of 1 to 5 of each month to verify if people from a condominium made the payment, but to place them in default. I was researching and I believe that I date period with date interval, it is th...
asked by 12.08.2018 / 14:59
3
answers

How to convert a string into a date with PHP

Can someone tell me how to convert a string with a date in this format "2000-01-01 00:00:00" to an object of type Date ? I get the date from a query to a database mysql . I know it must be silly, but I can not do it....
asked by 27.03.2018 / 13:41
1
answer

Filter by weekend in a certain range of hours. Django

I am trying to make a query that I return the number of orders that your delivery date is during the weekend between 7 am - 11 am and I have been trying this way: Order.objects.filter(delivery__range=[breakfast_start_date, datetime.now()], sta...
asked by 13.03.2018 / 23:07
1
answer

How to calculate the average of the differences between timestamps in php?

Good afternoon, this is the first time I ask a question. I have an array of data with timestamps. First of all I'm calculating the time difference between each of those brands. That calculation I'm doing it using the function --diff-- of...
asked by 20.01.2018 / 18:04
1
answer

Intervals of time between records

I have a table that is composed as follows:    Schedules id int(11) pk uq nn ai inicio datetime nn default "CURRENT_TIMESTAMP" fin datetime null default "CURRENT_TIMESTAMP" tipo tinyint(1) nn default 0 eliminado tinyint(1) nn default 0...
asked by 12.01.2018 / 17:36
1
answer

python and date loop

good, I am trying to create a vector that when entering a start and end date, dates are generated in between every 6 months and I can not do it in python :(. for example when I gave the input 01-01-2010 and 01-01-2012 I want the vector to contai...
asked by 19.11.2017 / 06:37
2
answers

last 2 months Different

I have a registration list for each SKU; then for each SKU I would like to be able to obtain the prices of the last 2 months Different (Months registered) (and that I can recognize between annual changes like December 2016 and January 2017) th...
asked by 23.10.2017 / 19:33
2
answers

convert timespan to datetime and add to a datetimerpicker

I want to show a data type of time interval in a datatimerpicker, first I must convert, but I do not know how to do it private void button1_Click(object sender, EventArgs e) { TimeSpan a = new TimeSpan(12, 00, 00); TimeSpan...
asked by 29.08.2017 / 16:35
1
answer

Datetimepicker does not show default date value

I need to show the default date in all the fields, but when adding the option of the minDate: new Date () plugins the dates in the fields are not shown, but if the value is internally in the field. Example: Code: $(func...
asked by 22.08.2017 / 18:35