Questions tagged [y10k]

2 questions
3
votes
1 answer

Achieve DateTimeFormatter Y10K output equal to SimpleDateFormat?

While writing unit tests for some date helpers i stumbled across a particular behaviour of DateTimeFormatter that i would like to understand how to get around. When outputting years >9999, it always adds a plus sign in front of the year number. Some…
Philzen
  • 3,945
  • 30
  • 46
0
votes
0 answers

Dealing with an invalid date in OpenQuery

I am running an OpenQuery in SQL Server against a proprietary database which has unfortunately chosen to be overly modern and support 5 digit years and users being users do manage to record them. The code I have written is working, but gets unduly…