Questions tagged as 'date'

1
answer

PHP / MySQLI Syntax Error

What happens? I think it's well built, but obviously something is missing. Name of the Table: citas Field Name: idcita, horacita, diacita, asuntocita    Query Error 1064 You have an error in your SQL syntax; check the   ma...
asked by 14.11.2018 / 15:17
2
answers

PHP - Validate if a date passes through another

It happens that I have a table where I keep records of things that are going to be done with a format: task, start date, end date Example: Pruning the lawn, 2018-02-20, 2018-02-25 What I need is that you can not register in the BD tasks th...
asked by 16.02.2018 / 17:38
3
answers

Print an array of dates

Array ( [Monday] => Array ( [0] => 2017-07-03 [1] => 2017-07-17 [2] => 2017-07-31 ) [Friday] => Array ( [0] => 2017-06-30 [1] => 2017-07-14 [2] => 2017-07-28 ) ) My goal is to get...
asked by 03.07.2017 / 17:29
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
1
answer

SimpleDateFormat for month abbreviated in 3 characters

I am having problems when paging dates that express the abbreviated month to 3 characters. I use a SimpleDateFormar that I build in the following way: DateFormat dateFormat = new SimpleDateFormat("dd MMM HH:mm yyyy", new Locale("es")) ; Whe...
asked by 20.08.2018 / 19:02
1
answer

Help / Tips for manipulating dates and formats by reading them with a BufferedReader

I made a program that reads a txt file line by line with a BufferedReader. If the line that reads finds the String "Issue Date", it takes from character 83 to 93 of that line (which would be the actual date) and saves it in a String variable to...
asked by 18.10.2018 / 15:26
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
1
answer

How to format DD / MM / YYYY in a Date type field of a table in oracle?

I have a query which gets some Date type fields The result of this query is downloaded to a .csv file and what it does is that it does NOT show the date fields in DD / MM / YYYY format, try to convert them with to_char but when you sho...
asked by 25.07.2018 / 05:46
1
answer

Subtract hours from a datetime in MySQL

I have a field which is a datetime, this field returns the following date / time: 2018-05-16 14:37:45 What I would like is to be able to subtract 5 hours from that date and make it look like this: 2018-05-16 09:37:45 I could achieve th...
asked by 16.05.2018 / 17:51
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