Most voted "date" questions
Date is the representation of a specific point in a calendar, usually represented by a day, month and year, the values of which may vary according to the culture and calendar used.
Learn more…887 questions
Sort by count of
-
0
votes2
answers103
viewsdata conversion problems with php
I have the following function that transforms timestamp into English readable date function dataEmPortugues ($timestamp, $hours = TRUE, $timeZone = "America/Sao_Paulo") {…
-
0
votes2
answers86
viewsI do not know how to call a certain item on the list that enters my "for" in other functions
I’m trying to make a program that picks up a list of partners that contain the name, email, and renewal day(like paying monthly fee), and when the day comes, send an email to it. But I’m having…
-
0
votes0
answers163
viewsFormat all Date objects in Cakephp 3
In my database I have some fields with the Date type. Therefore the data is stored in the format '2016-01-23'. However, when I retrieve this data to display it in the VIEW, it appears in the format…
-
0
votes1
answer307
views -
0
votes1
answer92
viewsORACLE Date Error
Although I have many materials on the subject , nothing has helped me to solve. I am trying to make a simple query in an oracle database and get an error, follow the error. OCIStmtExecute:…
-
0
votes2
answers9290
viewsHow to Check whether the date is valid or invalid?
I’m learning Java on my own and I came across an exercise that I don’t know where to start researching. I found something about datetime, Try, catch. But I couldn’t quite understand why the examples…
-
0
votes3
answers707
viewsFormatting dates for display and storage
In this Android app, I have a date field in the SQLITE database table, thus defined: String createTable = "CREATE TABLE " + TABLE_RUNS + " ( " + _ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +…
-
0
votes1
answer2523
viewsJsonformat changing date on a get request
I have a java web service using Spring Boot, in a class I have a date attribute and I use Jsonformat to format the date and convert on the client side using Gson. However, even defining the locale…
-
0
votes1
answer107
viewsJavascript Sharepoint Compare Data Field with Date Today
I have a list at Sharepoint with the code below: I need to compare the date of the field "Data_x0020_de_x0020_delivery" with the current date "today", but by the code below is comparing only the…
-
0
votes1
answer31
viewsInsert date in bd with JDBC Google Script
I am trying to write several data in the database (Mysql), but in the data of the date type the following error: Unable to find setTimestamp(number,string) method. (line 32, file "Code") The code…
-
0
votes1
answer151
viewsTake the last id generated in the Insert with jquery and redirect to another page
hello, I’m having a hard time getting the id generated in php with jquery, so I can send this id to another page, follow the code: queryInsert.php $assunto = $_POST['assunto']; $msg = $_POST['msg'];…
-
0
votes0
answers422
viewsHow to create a calendar field in PHP or Javascript?
I need the following, to have an open calendar (if possible already come with yesterday’s dates back blocked) to make service scheduling, when clicking the date X, then I’ll throw that date in a…
-
0
votes1
answer68
viewsWhat is the most recommended and performative way to manipulate dates in PHP?
In PHP we can manipulate dates using functions such as date, strtotime, mktime etc. and from version 5.3 of it we can manipulate dates object-oriented with the classes Datetime, Dateinterval,…
-
0
votes1
answer79
viewsDate and Time Data Type Elements
Personal I would like to ask a question, we should treat differently fields that have as kind of data time and date I say in relation to the view, Why I have a problem I need to plot some date and…
-
0
votes1
answer3508
viewsHow to work with C Dates?
Speak up your people! I took a question here on the internet to do that nothing comes out at all. He asks the following: Want to make a program that reads the name of the book that will be borrowed,…
-
0
votes1
answer1360
viewsProblem adding month to a php date
I’m having a certain problem adding months with php, had done using the Modify but as in the documentation itself already informs that of the error, then I tried other 3 functions I found and then…
-
0
votes1
answer813
viewsComparing dates
My problem is that I am not sure how to compare two dates. I would like to compare a date that the user types, compared to the current date. If the date type is less than the current one, the…
-
0
votes3
answers353
viewsAverage time in seconds
Hello, in my select I need to find the average service time (TMA) between two columns BIGINT format being them: Date: Dtbegin (start) and Dtend (end) They are of the format "dd/mm/yyyyyy hh:mm:ss",…
-
0
votes1
answer322
viewsConversion to date Postgresql
Hello, I am working with a database that has date information stored in a varchar(50) as in the following example: "2012 December 2 18:37". I need to do research based on time intervals. However, I…
-
0
votes1
answer63
viewsPerform a search from a certain date
I’m reading a csv file that generates data from when a particular page was accessed. However I am not able to implement a method that allows me to perform the research from a date I wish. Follow the…
-
0
votes1
answer207
viewsManipulating dates
I have doubts about the steps to manipulate dates. The steps below are ok? Can I start studies? I have the attribute Date and I want to insert 2 days. Convert Date in String. Convert String in…
-
0
votes1
answer796
viewsrestrict options for type="date" and type="time" fields
I am making a scheduling form. The company is not 24 hours and does not work every day of the week. In this case I need to narrow the options according to the company calendar. I thought to validate…
-
0
votes2
answers169
viewsShow date in Messagebox C#
I have a date vector with the values already entered, but I wanted to show the values one by one, so I created a "for" that did this Dataavailable is my date vector, with values already allocated;…
-
0
votes1
answer479
viewsSearch data between a period in a table with start date and end date fields
I’m having a problem searching for data in a table with start date and end date fields between a period (a - up filter) The sample data are: ID - INICIO - FIM 1 - 01/01/2017 - 31/12/2017 2 -…
-
0
votes1
answer525
viewsCapture visitor’s local time
Hello, for security reasons I need to pick the time the visitor of the page entered, but the system apparently is taking time from the server. IP: [XXX.XXX.XXX.XXX] Date: [03-07-2017 - 14:05:49]…
-
0
votes1
answer402
viewsMysql - Update column with Brazilian date value
I am updating a table in a bank with more than 100 thousand records to be able to perform future SELECTS to generate a statistical report. The table currently has a 'Birth' column of type…
-
0
votes1
answer1280
viewsChange date column to timestamp
I have a table with a column like date but I need to see the GMT information, my idea is to convert it to timestamp. How can I change that even if the column already contains value? create table…
-
0
votes0
answers125
viewsField Date register date
I have a table that one of the fields is date type. On my page insert.Asp when I type the date for example so 10/07/2017 or 2017-07-12 not saved in Mysql database. The error that is shown is this:…
-
0
votes1
answer334
views -
0
votes2
answers154
viewsHow to remove Duplicate dates in sql?
Good morning, I need some help for the following problem, I have this code Which gives me the following result, but I’d like to remove the duplicate dates From now on, thank you.…
-
0
votes0
answers105
viewsRegistration of dates from the calendar
I am trying to make a record of recurrence of dates for an event, I have this calendar: https://procurandooquefazer.com.br/data_calendario/ I wanted it to be possible to click on each date,…
-
0
votes1
answer290
viewsWork with Date in Mysql, JPA
I’m using JPA and creating an entity to store one date within the database. So far so good, the problem is that I need to display the database information according to the month of my date. Do you…
-
0
votes1
answer149
viewsDoubt Javascript Date() [front-end]
I’m building a personal blog using Github Pages and a desktop app con NWJS to do the back-end administration however I have a big question when presenting dates on the front-end. As it comes to a…
-
0
votes1
answer264
viewsBackdate in mysql
Good morning to you all! how do I, in a query in mysql, find the date related to 3 months ago?
-
0
votes1
answer68
viewsHow to make a date in ISO 8601 format but still be a Datetime
I wanted to know how I can transform a Datetime into an ISO 8601 format but keep it in a type of Datetime
-
0
votes2
answers6727
viewsDay of the week by php variable
I want to take the date in full. The code below is getting right, however, the current date of the computer. I would like it to be as I put the date coming from a variable type 01/09/2017. <?php…
-
0
votes1
answer148
viewsDisplaying dates in forms
I am creating a form that contains a field whose data type is DATE, where I want a certain value returned by default. But there’s nothing I can do to make it happen. My code is this: <?php $ini =…
-
0
votes0
answers75
viewsHow do I convert Date to String ? (Java Language)
public class Passageiro { public static void main(String[] args) { Viagem passageiro = new Viagem(); passageiro.nomePassageiro = JOptionPane.showInputDialog("Digite o…
-
0
votes3
answers69
viewsHow to read only Formatdatatime numbers
I needed to know the current time of the computer and compare with values in the database, example: 'agenda.hora >= "' + formatdatatime('hh:ss',now) + "; It turns out that both in the bank and…
-
0
votes1
answer99
viewsCreate an int variable that recognizes numbers in time format
I have a variable int that is taking the current time of android and comparing with more dua variables int of my database in the parse that contains the opening and closing time of a company, in…
-
0
votes0
answers76
viewsConstant change of dates in Codeigniter
I have a site developed in PHP and Codeigniter, never worked with PHP or Codeigniter, only with Javascript. The problem is that the date of the site ads is constantly updating, which was to be…
-
0
votes1
answer3159
viewsQuery sql with longer and shorter date limit
My code should return values from the database, related to the current day (today), but only related to the month and day, I searched a lot but could not find something to help me $data_atual =…
-
0
votes1
answer489
viewsHow to Save the Date Field of a Java SE Application in Postgresql
I need to save these two dates (ALLOCATION DATE and RETURN DATE) from an allocation, where I have the following Allocation Table: CREATE TABLE public.aloca ( alocod serial NOT NULL, alodtdevolucao…
-
0
votes2
answers834
viewsDate in Portuguese returning in English
I am using this code to return the current date in English (locally): <? setlocale(LC_ALL, 'pt_BR', 'pt_BR.utf-8', 'pt_BR.utf-8', 'portuguese'); date_default_timezone_set('America/Sao_Paulo');…
-
0
votes1
answer243
viewsHow to check if a time interval has conflicting dates with another time interval in php?
I am building a system in php to check if a given time interval has conflicting dates with another time interval. It is possible to do this? Example: I have two date ranges: 10/05/2017 until…
-
0
votes2
answers326
viewshow to save date with Date type in MYSQL and return to an Android app
Hello I have an Android application that takes the date of a Datepicker but I’m not able to convert it to the type accepted by MYSQL in the case Date how could do this?
-
0
votes1
answer47
viewsDate on a Highstock Chart
I’m trying to create a graph with the framework Highcharts, to create a chart, which framewor itself makes available, highstock. I’m trying to generate a graph like line, the values are correct, but…
-
0
votes1
answer397
viewsFunction that transforms the date into Brazilian and American format?
How would a function that when called, turns any date (valid) to the contrary? For example, I typed: 21/04/2017 will return as 2017/04/21; If I type: 2017/12/31 will transform into 31/12/2017;…
-
0
votes1
answer109
viewsHow to capture backdate
I have the following question. I have to capture two dates, one being today and the other being 15 days back. To get the date of the day I did the following. function dateFormat() { var initialDate…
-
0
votes0
answers71
viewsProblem saving month - Mysql Workbench
Good afternoon, I am doing a project for project management and I have in the registration form, two dates fields, when entering, when I consult the bank, the dates appear with the wrong month, all…