Questions tagged as 'data'

Tagged questions
1
answer

How to change the date format in SQL Server 2008?

Currently my bank is in YYYY-DD-MM format I would like to in MM-DD-YYYY. I found the SET DATEFORMAT only that is not the best option since I will have to add it in all querys . Is it possible for me to configure it on my connection...
asked by 28.04.2014 / 21:36
1
answer

Problem in displaying JCalendar-1.4

Hello, fine, everyone! I'm creating a program and I'd like it to have a calendar on the main screen. I searched and found jcalendar-1.4, but when adding it some numbers are not displayed (they get three dots). Could someone help me with the conf...
asked by 13.04.2014 / 20:13
1
answer

Add two or more covariates in R

I have a database with multiple IDs (rows) and in the columns the covariates. These covariates are repeated in other columns with different information about the same ID. How to join these covariates using R in a single column and creating more...
asked by 27.03.2018 / 06:05
1
answer

SQL / ORACLE Filter active records in month

I have a table that writes my records where one column writes the data_inicial and another column the data_final . I need to generate a report where the user searches all the records that were between the period of eg 03/03/2017...
asked by 10.04.2017 / 19:41
4
answers

If no where condition SQL Server

I have a Stored Procedure where I need to do a check for a date filter, if the start date is null I have to do in WHERE to get all records smaller than the end date, otherwise I make BETWEEN between dates. Example If...
asked by 15.11.2018 / 12:26
1
answer

Error Restricting Dates in SQL Server

I get 3 bases that are mounted in different places, these bases come to me in text file (.txt) and I do the import to SQL Server. I'm doing a query in which I want to restrict the records only for the year 2014 but even putting Data >...
asked by 21.11.2014 / 13:43
3
answers

Test equality of values (date) in PHP

Hello, I need to test if two dates are the same in PHP (current date vs. last day of the month), both are strings, but I'm not getting the result using the following code: if(strcmp($ultimo, $hoje) == 0) echo "<br><br>As duas...
asked by 31.07.2014 / 23:00
2
answers

How to read data with variables in rows, in RStudio?

I'm starting with the R language in Rstudio. I am an advanced user of MATLAB but with difficulties in R. My question is: I have a worksheet where each row is a variable and each column is an observation in the time series. I would like to kno...
asked by 16.01.2016 / 16:30
1
answer

Change color of a Row when VB .Net expires

I have a database with the following tables: Data Emissão and Data Expira . So I want that when the date of Data expira is equal to or greater than Data Emissao , row change color to Vermelho and when i...
asked by 29.04.2015 / 20:36
1
answer

Change varchar field yyyy-mm-dd hh: mm: ss to date dd / mm / yyyy in SQL Server

Dear, I'm extracting data from a satisfaction survey log, and I'm trying to create a column with the date format, so I can group the days and months into an Excel PivotTable. For more details, follow the field varchar with the date:...
asked by 29.08.2018 / 13:04