Questions tagged as 'datetime'

Tagged questions
1
answer

How to load my DatePickerDialog in Android 24-hour format?

How can I improve the following code that I will share so that when I click on a button I will load the DatePickerDialog in 24 hours format if or yes, since at the moment it loads me in the format that the user has configured in his system, eith...
asked by 31.08.2017 / 20:00
1
answer

How to remove the following error from my datetime picker in cakephp 3?

Hello good day, sorry I have this problem in my project. It happens that you add a datetime picker and it works but the problem is when I add the time the form stays in this state.  Here I present my code of add : <div id="datetimepi...
asked by 21.09.2017 / 23:20
2
answers

Method that receives datetime nulleable, change format to MM / dd / yyyy

I have a question .. I have a method that receives several dates in datetime format (dd / mm / yyyy) Something like that public ActionResult Reports(DateTime? FechaInicio, DateTime? FechaFin, DateTime? IptSemana, DateTime? IptDia) At the...
asked by 10.08.2018 / 00:10
1
answer

Error in function to add data type TIME

I have the following problem with a function that I use to add two hours, one of the hours comes from a query, which is a TIME type field and the other hour is the one I send for a POST. What I want is to add to the time that the query brought m...
asked by 21.05.2018 / 07:03
1
answer

Change time to UTC

I have a doubt I think simple: I have a time read in a file and want to change it to UTC format. For example: #esto es lo que tengo importado: import datetime ,time from pytz import timezone def cambio_fecha_hora_utc(): fecha = 201806...
asked by 13.06.2018 / 17:41
1
answer

Error converting the data type varchar to datetime

My problem is I want to add three dates that are in datetime format in sql. these date variables are in an SP and when sending the information manually in sql server: exec spInsertaCargoCobranzaMV '00024','002',21554,1,0,500.00,'5-19-2017',...
asked by 15.11.2017 / 01:25
2
answers

Sum of times sql server

I want to do a triggers query in SQL Server for the following: A calculated field my column subtracts is the difference between two dates and I want the total column to make me the sum of those differences plus the difference of the previous...
asked by 05.07.2017 / 18:47
1
answer

Datetime-Local to Y-m-d format H: i: sP '?

I'm working on angular and I'm saving the datetime of two datetime-local with a ng-model <input type="datetime-local" ng-model="column_Data.date_Start" placeholder="yyyy-MM-ddTHH:mm:ss" min="2014-01-01T00:00:00"> and then I am sending...
asked by 02.06.2017 / 17:31
4
answers

How can I get today's date from a string and not the full value of it?

I have an application which I need to export several values. In one of them I have a string that returns a date with time included "2/8/2017 10:26:35 AM". What I need is to extract this string but only validating the day the code is executed....
asked by 08.02.2017 / 18:31
1
answer

SQL - Filter by range dates with double column

Hi, I have a problem with a query. I want to filter by date ranges with two columns. Start and End. X | Inicio | Fin 1 |2018-10-01 | 2018-10-31 2 |2018-11-01 | 2018-11-30 3 |2018-11-15 | 2018-12-15 Inicio BETWEEN @parametroInicial...
asked by 23.11.2018 / 17:14