Questions tagged as 'datetime'

Tagged questions
2
answers

Problems to consult PHP night data

I have the following query to show the average temperature and relative humidity of the last two nights from the current date: SELECT DATE(date) AS Fecha, ROUND(AVG(temperature),2) AS Temperatura, ROUND(AVG(humidity),2)...
asked by 29.09.2016 / 14:25
2
answers

How to know if several periods of time overlap?

I need to iterate an array of date objects, with duration and get how many overlaps each of them. But I'm looking to do it efficiently and quickly. I'm looking for frameworks to manage time periods but I have not found anything. I develope...
asked by 23.02.2016 / 15:12
1
answer

Apply event to DatetimePicker when clicking on a date

Good afternoon, I'm using the DatetimePicker plugin and I'm trying to apply an event when a date is pressed, for example, when selecting a date automatically, an alert is generated. I have dealt with the onclick event but I can not get it to wor...
asked by 02.05.2017 / 17:11
1
answer

Control date between client and server in PHP

I have made a small event registration module, taking between date and time fields: YY-mm-dd H:i:s . Users who register can be from different time zones. Then an event scheduled for a moment could not correspond with the other clients....
asked by 08.02.2018 / 04:22
0
answers

Problem with the response in an ASP.NET Web API

I have an ASP.NET Web API that is working correctly on other servers, I'm just being presented with a detail on a particular server and the problem has to do with the dates. I have a class to perform the conversion of the dates and it is: p...
asked by 14.06.2018 / 20:32
3
answers

SQL query to filter by date a Datetime without including the time

I have a query in sql that looks for some XML by date range, but I think that it is not returning results since the where is with the datetime and I only send the date .. Any suggestions? SELECT A.e_rfc,a.fecha as fecha,C.SupplierName ,A.folio...
asked by 27.08.2018 / 17:37
2
answers

Convert datetime "DD / MM / YYYY" to a string "YYMMDD" in C #

I have the value of a date in a DateEdit which the default value is DD/MM/YYYY and I need to convert it to a string format YYMMDD to show it in a TextBox since it will define the name of a task on that date....
asked by 09.08.2017 / 16:30
2
answers

Convert 'dd / MM / yyyy hh: mm: ss' to 'hh: mm: ss tt', SQL Server

Assuming I have the following Date / Time in a tabla of the Database:    Entry : 05/03/2018 08:00:00.000   , Exit : 05/03/2018 18:00:00.000 I need to get the following output: Entrada : 08:00:00 a.m....
asked by 05.03.2018 / 20:08
2
answers

How to truncate a date with time in postgresql?

Execute: SELECT NOW() and it appears to me: '2017-08-07 10:53:44.207-06' And I want to appear '2017-08-07'     
asked by 07.08.2017 / 18:55
1
answer

Translate DatetimePicker from Bootstrap

Good morning, I am making a form in which you have to fill in several fields, including a calendar to choose a date. For this I use DatetimePicker. I get the calendar to work, but I can not change the language (I have tried changing the order of...
asked by 02.05.2017 / 10:34