Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › Year defaults to wrong century when INSERT on a Date field

View all replies to this thread

Year defaults to wrong century when INSERT on a Date field

Thread began 12/30/2015 8:26 pm by LionsMane | Last modified 12/31/2015 3:46 pm by LionsMane | 400 views | 1 replies

12/31/2015 3:45 pmRay BorduinWebAssist

You need to use a four digit year... This is what is commonly referred to as the Y2K issue. Code has no way of knowing what you mean with two digit years.

what would you expect 12/25/99 to be? is your date always in the future. I suppose we could hand code a solution for you that would add the 20 in front of any year input so that the user could input a two digit year and it would convert to a four digit year in a premier support ticket, if that is indeed what you want or need.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.