Home News Contact Us Forum About Us Demos Products F.A.Q.
ARI Soft









Register   Lost Password?
Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin







e-mail: info@ari-soft.com
Shopping Cart
You currently have 0 items in your cart.
Show Cart


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.
    more...

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.
    more...


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?
ARI Soft Forum
Joomla components
ARI Data Tables

[SOLVED] Date format, server side pagination
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: [SOLVED] Date format, server side pagination
#59333
Re:Date format and problem with server side paginatio 8 Years, 9 Months ago Karma: 0
Hello
I need to locate date format into my language.
I used the code:
set LC_TIME_NAMES = 'cs_CZ';
SELECT tc2, tc5, tc4, DATE_FORMAT( tc1, "%e.%M.%Y" ) AS datum, id
FROM sbhgl_chronoengine_chronoforms_datatable_treningove_casy
ORDER BY tc1 ASC

when you add set LC_TIME_NAMES = 'cs_CZ';
I'm reports an error: SQLSTATE[HY000]: General error
please, give me an advice
mkcup
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#59334
Re:Date format and problem with server side paginatio 8 Years, 9 Months ago Karma: 765
Hello,

It is not possible to execute several queries. If want to format date using current Joomla! locale, use "date_format" format filter. For example if want to format "datum" column, set "Columns settings -> ID" parameter to datum value and populate "Columns settings -> Format" with the following value:

{$value|date_format:%e.%M.%Y}

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#59335
Re:Date format and problem with server side paginatio 8 Years, 9 Months ago Karma: 0
Thanks for the advice, but I use ARI Smart Content - GChart
and there Columns settings does not work
It is another solution??
mkcup
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#59339
Re:Date format and problem with server side paginatio 8 Years, 9 Months ago Karma: 0
Please any idea how to insert format ARI Smart Content - GChart
mkcup
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#59340
Re:Date format and problem with server side paginatio 8 Years, 9 Months ago Karma: 765
Only possible way is used "date_format" filter. It will not work if "Revert data" parameter is enabled.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#59341
Re:Date format and problem with server side paginatio 8 Years, 9 Months ago Karma: 0
Thanks for the reply
Revert data I'm still not off format
I send setting image

mkcup
User Offline Click here to see the profile of this user
Last Edit: 2017/01/12 22:15 By mkcup.
The administrator has disabled public write access.
 
Go to topPage: 123
ARI Soft Forum
Joomla components
ARI Data Tables
Powered by Kunenaget the latest posts directly to your desktop
Useful Links
Products
F.A.Q.
Discount
RSS
Top Products
ARI Data Tables
ARI Sexy Lightbox
ARI Quiz
ARI Stream Quiz - Personal
ARI Smart Content
Help
Forum
F.A.Q.
Home | News | Contact Us | Forum | About Us | Demos | Products | F.A.Q.
ARI Soft
License | Terms and Conditions | Copyright Info | Privacy Policy
 
ARI Soft
Copyright © 2009