Significance of date 02/31/2157?
Posted
by
dpatchery
on Stack Overflow
See other posts from Stack Overflow
or by dpatchery
Published on 2011-01-11T15:22:32Z
Indexed on
2011/01/11
17:53 UTC
Read the original article
Hit count: 204
I work in a large scale IT support environment. Twice now we have seen an invalid date of 02/31/2157 being inserted in an Oracle DATE column. So far I have not been able to reproduce this problem, but it appears to be happening occasionally when a user attempts to save '00/00/0000' into the column. I believe the value is originating from a PowerBuilder DataWindow update.
The application uses myriad libraries for all sorts of technologies, so this question may be a bit vague, but...
Has anyone seen the date 02/31/2157 in some established library that Oracle could be defaulting to when some other invalid date is entered? Perhaps an end-of-time concept analogous to the beginning-of-time date of 1/1/1970?
© Stack Overflow or respective owner
