Birthday format

Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated

Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Birthday format

11 years 2 months ago

#139014

Topic Author
Victor Hugo
Offline
Fresh Boarder
Posts: 1
Thank you received: 0

Licenses:

JomSocial Active

Hi...
I'm having troubles with the way that the date format is stored in database...
1. When you write the birthday in the backend it recive in the format 2014-08-18 (YYYY-MM-DD)

2. When you see in database... the birthday is stored as 2014-8-18 (YYYY-M-DD)

This is causing problems.. because I'm developing a module that shows next birthdays.. but in database theres no uniformity...
I created manually the birthdays because I needed to import them from another source.. but jomsocial is not coherent with that

Attachments:

11 years 2 months ago

#139045

Albertus
Offline
User is blocked
Posts: 3296
Thank you received: 2582

Licenses:

Hi Victor,

here my suggestions:
if that module that you developed using MySQL query, you can use

DATE_FORMAT(datefield,'%Y-%m-%d')

if using php you can use

$newDate = new DateTime($datevalue);
echo date_format($newDate, 'Y-m-d');

so the date output will uniformity.

Regards

Moderators: Piotr Garasiński

Notice

Support Forum

Birthday format

Licenses:

Attachments:

Licenses:

Join 180,000 websites creating Amazing communities

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere