- Dec 1, 2000
- 2,419
- 0
- 0
This DOES belong in off topic, because it is a RANT.
I was formatting a date in the form "yyyy/mm/dd".
I started using my app and making it select work orders for certain dates (formatted as above).
The strangest things started happening... sometimes I'd get what I wanted, other times it would just start picking word orders randomly, and then I got nothing.
This happened betwen 4:00 and 4:13 pm when I finally got an exception: "Cannot convert 2004/13/22 to a timestamp"
13? WTF?
Turns out as my clock was ticking through 4:00, 4:01, 4:02, I was getting January, February, March...
For anyone who cares, C# format strings use CAPITAL Ms for MONTH! Small m is MINUTES!!!
I was formatting a date in the form "yyyy/mm/dd".
I started using my app and making it select work orders for certain dates (formatted as above).
The strangest things started happening... sometimes I'd get what I wanted, other times it would just start picking word orders randomly, and then I got nothing.
This happened betwen 4:00 and 4:13 pm when I finally got an exception: "Cannot convert 2004/13/22 to a timestamp"
13? WTF?
Turns out as my clock was ticking through 4:00, 4:01, 4:02, I was getting January, February, March...
For anyone who cares, C# format strings use CAPITAL Ms for MONTH! Small m is MINUTES!!!
