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


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


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 11 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 11 Months ago Karma: 671
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 11 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 11 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 11 Months ago Karma: 671
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 11 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 15:15 By mkcup.
The administrator has disabled public write access.
 
Go to topPage: 123