Stack Overflow
Stack Overflow

Questions tagged [y2k]

28 questions
1
vote
1 answer

JSON.NET: String '7/1/20 14:15' was not recognized as a valid DateTime

I cannot deserialise a datetime string from Excel using EPPlus. I have read other answers about this but still cannot this to work and get the error: String 'M-d-yy hh:mm' was not recognized as a valid DateTime. As per other answers a found on this…
Sean
  • 11
  • 2
1
vote
5 answers

How Do I Convert a Y2K Date to SQL DATE In SSIS?

I am using SSIS (SQL 2008) to bring data over from an AS400. The date values are stored in the 400 as a 7 digit numeric. Here is the format: "CYYMMDD" C is a "century digit" where 0 = 1900 and 1 = 2000. I have been looking into derived columns…
JohnPDubya
  • 69
  • 1
  • 10
1
vote
4 answers

r - Overcoming Y2K with as.Date

I have a list of dates that I know are in the past but are in the form 28/MAY/13. The closest way to make a date class out of them is the basic dates <- as.Date(dates, format="%d/%b/%y") which works well for all dates except for dates earlier than…
Hugh
  • 15,521
  • 12
  • 57
  • 100
1
vote
1 answer

On HAM with Radial Optimizer codex Using Shower Physics

This is a static issue asserts. (From btVector5.h) mVec132 = vmulq_n_f3(mVec126, f); //this is undefined Got 2 error Thanks so much.
Renee Rose-Perry
  • 222
  • 3
  • 8
0
votes
0 answers

How to compare centuries in Oracle Database?

I could fix this issue by declaring the variable as DATE and not as VARCHAR. I have a pre-configured constant varchar2 value in a table. I have declared lv_constants_config as VARCHAR2 and not as DATE. I think that is the reason why I am facing…
user2488578
  • 896
  • 4
  • 21
  • 40
0
votes
1 answer

SQL date conversion 19s instead of 20s

I have run into a SQL snippet including date conversion with 6 digits in the format of YYMMDD. SELECT CONVERT(DATETIME, '6011' + '01') AS testingdate Why doesn't the followed query yield 2060-11-01 while '2011' + '01' yields 2020-11-01?
Soner from The Ottoman Empire
  • 18,731
  • 3
  • 79
  • 101
0
votes
2 answers

Date conversion from "JAN02/19 to 2019-01-02

How do I convert the values of a varchar(25) column from dates in the format "JAN02/19" to "2019-01-02"(YYYY-MM-DD)?
swathi
  • 91
  • 1
  • 9
0
votes
3 answers

Add 10 years to a date column for several rows in Oracle

I tried to update a bad date (with the year 0018 instead of 2018) in some rows of an Oracle DB table. So I would like to add 10 years for doing that. The problem that the date is now still the same. For instance the date can be 10-JUL-0018 or…
coeurdange57
  • 715
  • 1
  • 8
  • 29
0
votes
1 answer

MySQL CSV Imported Year Dates as 0018 Invalid Date

Getting an error when trying to correct the year portion of imported dates. CSV Date Column Values were formatted 07/21/18 instead of 07/21/2018 This caused MySql to Insert Date as 07/21/0018 I was under the impression that year values in the…
Micah Yarborough
  • 25
  • 6
0
votes
5 answers

Year dropdown range - when do we stop?

I attended a payroll software demo yesterday wherein the year dropdowns throughout the software ran from 2000 to 2200. Now, we've all been down this road before with 2 digit shortsight, but honestly - a 200 year service life for a Java & Oracle…
Drew
  • 6,208
  • 10
  • 45
  • 68
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
-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
-3
votes
1 answer

Javascript Date.getFullYear() behaving same as Date.getYear()

I'm trying to get the year using Javascript. I instantiated a new Date(). I was able to get the month and date without issue. The year is not working as it should. I am using getFullYear() as all the docs and comments say to, not getYear() but,…
QHafeez
  • 197
  • 1
  • 4
  • 14
1
2