A two digit year is a representation of the four number year shown only with the last two digits - for example, 12 being displayed rather than 2012.
Questions tagged [2-digit-year]
39 questions
0
votes
1 answer
How to update the value of a column to contain just the year-part of the date?
I have a full date-time in the column ANFISCAL. I would like to update the column to have just the year.
I used
UPDATE ANIFISCALI SET ANFISCAL=EXTRACT(YEAR FROM ANFISCAL)
but it doesn't work. I'm getting this error:
ORA-00932: inconsistent…
Alex
- 1
0
votes
1 answer
SQL query to find weekdays in continuous years
to everyone I am little bit of struggling with MySQL query i need to get list of Saturdays list for the past 5 years and i am confused so please help me!!
Venkatesan Rajaram
- 11
- 8
0
votes
1 answer
Two letter year, shall it be allowed?
Recently after library updagrade of Apache POI, I upgraded some other API as well. The other library I used read all cell contents as String and then I had to parse this string into Date.
The problem occurred when user started entering date as…
hanumant
- 1,091
- 4
- 15
- 27
0
votes
3 answers
Preferred method for handling Y2K date conversions?
Is there a preferred algorithm for converting a 2-digit year into a 4-digit year?
I have a 2-digit birth date (along with month and day) that I want to convert to a C# DateTime. Obiviously, birthdates cannot be in the future, but is there an…
Ian Boyd
- 246,734
- 253
- 869
- 1,219
-1
votes
2 answers
How to get Current Year in YY Format in Java/Android
I am able to get Year in YYYY Format from my below Code. But I want in YY Format. Can anyone help?
Calendar c = Calendar.getInstance();
int seconds = c.get(Calendar.SECOND);
int hour = c.get(Calendar.HOUR_OF_DAY); // IF YOU USE HOUR IT WILL GIVE…
user1543571
- 57
- 2
- 9
-1
votes
2 answers
Regex: Email contain numbers but they are not on year pattern
I'm new using regex and, after some tutorials, I'm getting difficult to implement an match criteria like "Email contain numbers but they are not on year pattern".
So, I have this simple regex for "contain numbers":
\d+(?=@)
Considering that e-mail…
jbrettas
- 323
- 1
- 7
-2
votes
1 answer
Leap year and symbol used
How do I determine numbers divisible by 4? I'm trying to apply a leap year.
I see a lot of solutions that show a '%' symbol. What does it mean?
Douglas
- 1
-2
votes
2 answers
Convert date format: 2 digit year to 4 digit year
If I have a string that contain a date, like '29/01/21', how can I convert its format to a 4 year digit instead of 2 digits?
'29/01/21'
to
'29/01/2021'
Danilo Matrangolo Marano
- 892
- 1
- 10
- 17
-2
votes
3 answers
How to convert "yyyyMMdd" date format into "ccyyMMdd" simpledateformat in java
I want to convert the format from "yyyyMMdd" to "ccyyMMdd" simpledateformat in java. I am getting "c" as illegal character in java. Please help me to find the slution to convert in to "ccyyMMdd" format in java Simpledateformat
What is the differnce…
Chitra
- 13
- 1
- 7