Welcome, Guest

Datumsformat ändern in select-Anweisung
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Datumsformat ändern in select-Anweisung

Datumsformat ändern in select-Anweisung 2 years, 2 months ago #12477

Hallo zusammen,
ich habe mir ein Formular zur Anmeldung zu einem Turnier gebastelt. Dazu wird auch ein Geburtsdatum abgefragt, welches in folgendem Format abgespeichert wird:
JJJJ-MM-DD


Jetzt will ich in der Abfrageliste auch das Geburtsdatum anzeigen lassen. Das funktioniert auch soweit. Ich möchte das aber auch in einem anderen Format anzeigen lassen. Und zwar so:
dd.mm.jjjj


Habe folgenden Code in der Abfrage, welcher aber nicht funktioniert:
$rows = ff_select(
"select ".
"c.id as id, ".
"c.userid as userid, ".
"u.name as user, ".
"select date_format(c.geburtsdatum, '%d.%m %Y') as geburtsdatum ".
"from #__anmeldung_dvmjugend as c ".
"left join #__users as u on c.userid = u.id ".
"order by id"
);


Wo liegt der Fehler?
  • Page:
  • 1
Moderators: TheMuffinMan, ForumSupport
Time to create page: 0.56 seconds

Facebook Discount - 40% Off!

Fans of our Facebook page here are entitled to get a 1-year-subscription for the price of a 6-months!

Steps to take:

  • Become a fan on Facebook (Like) here
  • Purchase a 6-months-subscription from here
  • Write a quick email to This email address is being protected from spambots. You need JavaScript enabled to view it. with your username and prove of your like and we'll upgrade to the 1-year-subscription

Joomla!® Forms Discount - 40% Off!

Already purchased a forms extension from a different vendor but your requirements changed and now you need a forms extension that is capable of more than just the standards? We help you to keep the costs for a change under control: Get a 40% discount on our professional membership plan! -- meaning timely unlimited access to all current and future commercial extensions, breezingforms themes & apps and Joomla!® templates at crosstec.de, including 1 year of support -- without any website limitations -- Just prove that you previously purchased another forms extension for Joomla!® from a different vendor and you are qualified.

Steps to take:

  • Purchase a 1-year-subscription from here
  • Write a quick email to This email address is being protected from spambots. You need JavaScript enabled to view it. with your username and prove of the purchase for the other form vendor and we'll upgrade to the professional-subscription

About

Crosstec GmbH & Co. KG

Bergisch-Gladbacher-Str. 829

51069 Cologne, Germany

Imprint