Questions tagged as 'fecha'

Tagged questions
2
answers

mysql order per day of the week

Hello friends, could you help me, I would like to ask a query on a mysql bd to sort the records for the day of the week in which you are currently I have these records: +---------+----------+ | id_cron | day_week | +---------+----------+ |...
asked by 21.09.2017 / 21:11
2
answers

Validate that the date is not in the future [duplicate]

In a file js, thanks to the help and more research, I have already validated the correction of a date provided by the user. As it is a date of birth I would like to be able to control that it was not superior to the current date. In the follow...
asked by 01.04.2017 / 12:35
2
answers

transform number to date

I have the following number 34076 which is equivalent to the date 17-04-1993, which function can I use to transform that number to the date indicated, I am working with VBA and that number is retrieved from an excel to a datagridview.     
asked by 27.12.2016 / 16:10
1
answer

Display a date in one format and store it in another (Datepicker in Laravel)

I am working in laravel and I want to show in my Bootstrap Datepicker field a date in a format (dd / mm / yyyy) but I want to store it in format (yyyy / mm / dd). Is there any property in Datepicker to do that? This is my input: <div cla...
asked by 13.09.2018 / 20:18
2
answers

How can I format a String to date with PHP

Greetings as they are all I have this date with this format, it is a string Wed Sep 12 2018 14:47:35 GMT-0500 (Colombian standard time) and I want to cover it in this format 2018-09 -12 14:47:35 Someone knows how I can solve my problem....
asked by 12.09.2018 / 22:19
2
answers

query sql that counts how many days of each month there are two dates grouped by months

I come to you because I have searched and I have not found anything that can help me with the problem I have. I must show in a query in SQL Server how many days of each month there are between two dates but grouped by months (I have an Initial d...
asked by 04.01.2018 / 14:22
1
answer

Calculate how many hours and minutes have passed since a date in Java [closed]

I want to save the current date (day + time + minutes) in a database and then retrieve it in Java and calculate the difference in hours with respect to the current date. However, I would like that the time was not obtained through the system,...
asked by 17.06.2018 / 13:09
1
answer

Get the days of the week from a date - Javascript

Create a function that brings me the days of the week from Monday to Sunday : weekLabel(current) { const week = []; const weekFormat = []; current.setDate(((current.getDate() - current.getDay()) + 1)); for...
asked by 15.07.2018 / 19:56
2
answers

error when using the diff on dates with php?

I'm currently using the diff command in php to make a difference of two months, but that difference comes out but it's wrong it's not the correct one: Date today: 8-03-18 future date: 07-05-18 This is the result that I get:...
asked by 08.03.2018 / 17:48
1
answer

Laravel, show a user depending on the date (L-V)?

I want to do in laravel that shows a User depending on the day of the calendar. Suppose I have a DB with N users, and they must cover one day of guard in the L-V job in order of 1-N, ex: -Thursday 2 August: "It is up to you to guard the Us...
asked by 02.08.2018 / 21:26