OraFAQ Forum: Suggestions & Feedback » A small bug in Orafaq's Control Panel/Account Settings section

Home » Other » Suggestions & Feedback » A small bug in Orafaq's Control Panel/Account Settings section

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

A small bug in Orafaq's Control Panel/Account Settings section [message #595256]

Mon, 09 September 2013 14:15

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

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

However, it must be "Mon, June 22, 19XX".

Why?

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Frank Naude
Messages: 4587
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

Report message to a moderator

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

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!

Report message to a moderator

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

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Better? The forum will now use the current year if the birth year is not specified.

Report message to a moderator

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

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

LOL

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

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator