Timeline for Convert YYYYMM to MMMYY
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 17, 2020 at 9:04 | history | edited | CommunityBot |
Commonmark migration
|
|
| Jun 23, 2016 at 17:01 | comment | added | pajonk | Ok, just wanted to know. Thanks for clarification. | |
| Jun 23, 2016 at 13:47 | comment | added | t-clausen.dk | @pajonk according to this, you can use tables for input | |
| Jun 23, 2016 at 13:41 | comment | added | Giacomo Garabello | @pajonk in this answer nobody tell me anything about the use of tables | |
| Jun 23, 2016 at 13:39 | comment | added | Giacomo Garabello |
@t-clausen.dk the shortest way using print is 58 chars: begin:n:=to_char(to_date(:n,'yyyymm'),'monyy');end;print n and you need 42 extra chars for a single input(VARIABLE n varchar2;BEGIN:n:='201605';END;) instead of 31 (insert into t values('000112');) if you have shorter ways please tell me.
|
|
| Jun 23, 2016 at 13:38 | comment | added | pajonk | Is it allowed to take input from a table? The codegolf tag info suggests that no. | |
| Jun 23, 2016 at 12:37 | comment | added | t-clausen.dk | Would it be possible to use PRINT instead of SELECT and not refer to the table using a variable as input instead ? Declaring input variable and assigning the value does not affect the byte count | |
| Jun 23, 2016 at 7:06 | history | answered | Giacomo Garabello | CC BY-SA 3.0 |