Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 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.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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?

[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 7 Years, 2 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
The administrator has disabled public write access.
 
#59334
Re:Date format and problem with server side paginatio 7 Years, 2 Months ago Karma: 746
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
The administrator has disabled public write access.
 
#59335
Re:Date format and problem with server side paginatio 7 Years, 2 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??
The administrator has disabled public write access.
 
#59339
Re:Date format and problem with server side paginatio 7 Years, 2 Months ago Karma: 0
Please any idea how to insert format ARI Smart Content - GChart
The administrator has disabled public write access.
 
#59340
Re:Date format and problem with server side paginatio 7 Years, 2 Months ago Karma: 746
Only possible way is used "date_format" filter. It will not work if "Revert data" parameter is enabled.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#59341
Re:Date format and problem with server side paginatio 7 Years, 2 Months ago Karma: 0
Thanks for the reply
Revert data I'm still not off format
I send setting image

Last Edit: 2017/01/12 22:15 By mkcup.
The administrator has disabled public write access.
 
Go to topPage: 123