Questions tagged as 'data'

Tagged questions
1
answer

MYSQL PHP query bring results of Today and This Week

I'm setting up a CRM type, where it does the queries in MYSQL with PHP to bring the appointments I have today, this week and all others. I'd like you to bring something like this: Hoje: compromisso A compromisso B Essa semana: compromisso...
asked by 30.07.2018 / 19:42
1
answer

List days of the week, having the month and year PHP

I want to print the days of the week separated by the number of the week of a given month: What I have so far is: function days_week($date = NULL){ $date = ($date == NULL) ? date('m/d/Y') : $date; $ts = strtotime($date); $year = date('o', $ts...
asked by 26.04.2018 / 05:55
1
answer

sql search with higher and lower end date

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 that would help me $data_atual = date("d-m"); $mostraDados = mysqli_query(...
asked by 13.10.2017 / 07:42
1
answer

Displaying dates on forms

I'm creating a form that contains a field whose data type is DATE, where I want a given value to be returned by default. But there is nothing I can do to make it happen. My code is this: <?php $ini = date('d-m-Y'); ?> <form id="form1"...
asked by 13.09.2017 / 13:07
1
answer

manipulating dates in postgresql

I have a database with multiple records, from 2001 to 2010 . How do I select all tuples with dates after day 2001-05-02 ? Date is of type character varying(254) .     
asked by 25.05.2016 / 20:37
2
answers

Incomplete week name in strftime return

I'm trying to print the day of the week, according to a particular timestamp, with the function strftime . I'm doing the following: setlocale(LC_ALL, 'pt_BR', 'pt_BR.iso-8859-1', 'pt_BR.utf-8', 'portuguese'); echo strftime('%A', strt...
asked by 16.07.2015 / 15:22
1
answer

How to sort by date when day, month and year are each in a column?

Hello, I have the following situation, I have to sort a table by date, but for some particular reason the programmer decided to save the day, month and year in separate columns, since the database is in MySql, there is an effective procedure...
asked by 15.07.2014 / 03:07
1
answer

Add months to a calendar without modifying the original instance

I'm implementing a system in which I wrap a specific date in a variable of type Calendar and then I need to manipulate it. I would like to take the value of a few months added: Calendar calendar = Calendar.getInstance(); calendar.add...
asked by 29.12.2018 / 04:16
1
answer

Generate file D-1

How do I select data in D-1 format (current day - 1), what would VBA be a AGORA() - 1 , how would this be in postgreSQL? I have the following query and would like to get the day from yesterday to generate reports. select * from...
asked by 25.06.2018 / 15:13
1
answer

Add days to current date

I need to get the current date and add days according to the selected function calcular(){ var valor1 = parseInt(document.getElementById('dias1').value); var valor2 = parseInt(document.getElementById('dias2').value); var val...
asked by 18.05.2018 / 21:58