Home » Other » Suggestions & Feedback » A small bug in Orafaq's Control Panel/Account Settings section
A small bug in Orafaq's Control Panel/Account Settings section [message #595256] Mon, 09 September 2013 14:15 Go to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
If we enter our date of birth with only month and date, without specifying the year, it internally takes it as Y2K(2000). I mean nothing like I wanna keep my birth year/age a secret. But just found it while I tried to do so Smile
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595258 is a reply to message #595256] Mon, 09 September 2013 14:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The bug is yours, a date is day, month AND year... or do you want OraFAQ rejects what you enter? It seems the code chose another option.

Regards
Michel
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595262 is a reply to message #595258] Mon, 09 September 2013 14:41 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Michel, no more WARS on date formats /forum/fa/2866/0/...just kidding Smile

I know, D.O.B. column ought to be DATE data type, however, with a CASE and proper format mask it could be handled. Rather, a validation in the frontend page itself to ask to enter complete DATE. Look at my profile, it shows "Thu, June 22, 2000". However, it must be "Mon, June 22, 19XX".

It's just for a little fun, no pun intended.
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595298 is a reply to message #595262] Tue, 10 September 2013 00:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
However, it must be "Mon, June 22, 19XX".


Why?

Regards
Michel
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595301 is a reply to message #595298] Tue, 10 September 2013 01:31 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Sorry, please ignore the day and year. Obviously the system would not come to know about it until we feed into it. So, without the year, only the Date and Month would be displayed.

I know, per the industry standards and best practices we must insert the dates in DATA data type with full format of day, month and year. But what if someone doesn't want to share the year, and just the day and month, just to let the world know when to congratulate him/her on b'day eve Smile
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595303 is a reply to message #595301] Tue, 10 September 2013 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what if someone doesn't want to share the year, and just the day and month,


He can do it in the other fields of his profile, for instance "Biography" one.

Regards
Michel
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595304 is a reply to message #595298] Tue, 10 September 2013 01:50 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
It is stored as a MMDDYYYY string ('06220000' in your case) and indexed so we can easily pick the leading portion to get:

1. birthdays for this month (MM%)
2. birthdays for this day (MMDD%)
3. birthdays for today (MMDDYYYY)

I will try to fix the display bug later today.

Best regards.
Frank
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595305 is a reply to message #595304] Tue, 10 September 2013 02:02 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Frank Naude wrote on Tue, 10 September 2013 12:20
I will try to fix the display bug later today.

Best regards.
Frank


Wow! Thanks Frank.

Another encounter with Datetime literals!

Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595309 is a reply to message #595305] Tue, 10 September 2013 02:26 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Better? The forum will now use the current year if the birth year is not specified.
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595322 is a reply to message #595309] Tue, 10 September 2013 03:02 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
LOL Laughing

Now it shows :
SQL> SELECT TO_CHAR(TO_DATE('06/22','mm/dd'),'Dy,Month DD YYYY') "Date Of Birth:" FROM DUAL;
 
Date Of Birth:
----------------------
Sat, June 22 2013
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595323 is a reply to message #595309] Tue, 10 September 2013 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Current year when it is set or current year when it is displayed? (I vote for this later one otherwise I'd prefer the previous 2000 or even 0000 or 0001, if MySQL supports it)

Regards
Michel
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595328 is a reply to message #595323] Tue, 10 September 2013 03:16 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
It will DISPLAY the current year if it's not specified (left empty).
If the year is specified, it will show the year the user entered.
Re: A small bug in Orafaq's Control Panel/Account Settings section [message #595334 is a reply to message #595328] Tue, 10 September 2013 04:14 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK, that's fine.

Thanks.
Michel
Previous Topic: Need to delete my account
Next Topic: Same poster in multiple forums outside OraFAQ?
Goto Forum:
  


Current Time: Thu Mar 28 08:12:34 CDT 2024