Home Changing language of output
Reply: 0

Changing language of output

user671 Published in August 15, 2018, 11:15 am

I have this code to show some records out of my database. Now I have this timestamp and I am doing a Date_format on that records but this will display me the month ect in english and I would love to change it to an other languagefor example Dutch. How do I do that? So it wil display it in the correct language

How it is in the Database

SELECT DATE_FORMAT(create_time, '%d %M %Y') AS datum, reacties.*,
       klanten.foto, klanten.voornaam, klanten.achternaam
FROM reacties 
    LEFT JOIN klanten ON klanten.id = reacties.klant_id
    LEFT JOIN topics ON topics.id = reacties.topic_id
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.306609 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO