Stack Overflow
Stack Overflow

Questions tagged [yearmonth]

61 questions
0
votes
1 answer

Error computing item default value for page item DDL_MONTH_FROM. Contact your application administrator

I am new to Oracle APEX, i am using Oracle APEX version 20.2, i have page item called P720_DDL_MONTH_FROM. We are getting the value for that page item for date picker Month From is like below query. From the list of values page attribute: SELECT…
Johnny Miles
  • 21
  • 1
0
votes
1 answer

SQL Statement that will pull MINDATE from dates for current month and year

I need a sql statement that will pull the following the MINIMUM visit date for the current month and year (May 2021) emp_id visit_date 1 5/3/2021 1 5/4/2021 1 5/10/2021 1 6/5/2021 2 5/2/2021 2 5/6/2021 2 …
dnelson
  • 1
  • 1
0
votes
1 answer

Calcuation using SQL Server date for YYYYMM previous month

I am using Microsoft SQL Server Management Studio and I am trying to do the following: I want to make a calculation that looks for the last 2 months and the "current" month. The month and year are defined as follows: SELECT ID, dc.Year * 100…
alphasqrd
  • 53
  • 6
0
votes
1 answer

Java calendar using LocalDate

Hello I have a problem with a calendar. import javafx.application.Application; import javafx.scene.Group; import javafx.scene.Scene; import javafx.scene.control.Alert; errorDialogue = new Alert(Alert.AlertType.ERROR); dialogue =…
Martina
  • 1
  • 3
0
votes
2 answers

Add months to a date in format yymm

I am trying to add a specified number of months to a yymm formatted date. I'm having a hard time dealing with cases when mm exceeds 12. So, for example: 9109 (ie. 1991-Sept) + 17 months should yield 9302. 9103 + 3 months should yield 9106 Currently,…
FZ1712
  • 13
  • 3
0
votes
0 answers

tsibble::yearmonth does not convert properly the format "2016.11" and "2016.12"

There's a small issue with tsibble::yearmonth. See this list of year - months values: x <- c("2016.09", "2016.10", "2016.11", "2016.12") When I call tsibble::yearmonth (tsibble version 1.0.0), I obtain this: tsibble::yearmonth(x) [1]…
Marcel Baumgartner
  • 1
0
votes
3 answers

find gap between months in two consecutive year oracle sql

Need to find record having gap between months in a table if the data is present in two different year. I have column like id, value,month, year. Id, value, month,year 1, 123, oct, 2020 1, 128, nov, 2020 1, 127, jan ,2021 2, 121, Dec,…
Santhosh reddy
  • 101
  • 1
  • 3
  • 8
0
votes
2 answers

Subtract months from time in format year-month

I want to subtract months from given date in year and month format. global_date = "2017-01" I am converting it with the zoo library as follows: as.yearmon(global_date) - 0.1 but it gives me Nov 2016, I want it as '201612' How can I do it in R?
Neil
  • 7,937
  • 22
  • 87
  • 145
0
votes
1 answer

Transform an input with "month year" to "month/year" in R

If a time-related information is read as "Jun 2008". Are there any convenient approaches to transform it into date format in R or Excel, i.e., 06/2008?
user297850
  • 7,705
  • 17
  • 54
  • 76
-1
votes
2 answers

Querying dates within months using only numerical values months

I have 2 date values and a set of rows which have a range defined as discount_start_month and discount_end_month. The current situation is that I only have month information as below, there is no year data to compare the input 2 dates values with…
oldcode
  • 1,669
  • 3
  • 22
  • 41
-1
votes
1 answer

customize the display format of tsibble yearmonth column?

Can I customize the display format of the time series column in tsibble ? yearmonth allways like %Y %m，but i would like change the default format to %m-%y all over one chunk tsibble::format not working
Zeno Shuai
  • 109
  • 3
-1
votes
1 answer

How group by month

I'm having trouble finding out how to group by month-year. The below has error, Not a group by expression select dcst.stateid as stateId, dcst.crtdt , to_char(to_date(DCST.CRTDT,'DD-MON-YY HH.MI.SS."000000000" AM'),'Month') AS…
Michele
  • 3,617
  • 12
  • 47
  • 81
-1
votes
1 answer

List unique years from a set of dates in google sheets

I am currently achieving the process of extracting unique years from a range of dates with the use of helper columns shown here: Is it possible to achieve the same using just a single formula? Here are the three formulas I am currently using: S…
dan
  • 347
  • 2
  • 14
-1
votes
1 answer

How to convert year-month-day to just years in python?

So I have this column in a dataframe that has 4896 rows of datatimes in this shape: 2018-10-24 2014-04-10 2008-05-21 ... And I would like to transform or convert this data to years only (like 2018.15) -> convert the day and month to…
Sara Silva
  • 19
  • 7
-1
votes
3 answers

Group and sum values in associative array based on year substring in keys

I am trying to sum all of the yearly amounts based on an array with keys in a month-year ("M y") date format. $array_list = [ "Jan 2016" => 2, "Feb 2016" => 4, "Mar 2016" => 2, "Apr 2016" => 0, "Jan 2017" => 9, "Feb 2017" =>…
Dhiraj Kumar
  • 3
  • 4
1 2 3
4
5