[solved] datediff in the odometer

More
7 years 9 months ago - 7 years 9 months ago #34041 by yourcon
Hi,

nice and smart extension! Unfortunately this does not work (query type > expert):

SELECT DATEDIFF (day, current_date, '2016-08-26 17:00:00.0000000')

Where is the mistake??

very grateful for help!
best regards
ramona
Last edit: 7 years 9 months ago by nordmograph.

Please Log in or Create an account to join the conversation.

More
7 years 9 months ago - 7 years 9 months ago #34042 by nordmograph
Hi Yourcorn,

Here is the query I use on the front page
Code:
SELECT DATEDIFF(CURDATE(),STR_TO_DATE('1/1/2010', '%m/%d/%Y'))

So I guess you should try this:
Code:
SELECT DATEDIFF(CURDATE(),STR_TO_DATE('2016-08-26 17:00:00', '%Y-%m-%d %H:%i:%s'))

Hope it helps, let me know.
If you like the extension and support , feel free to leave a review at the JED, it realy helps :)

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.
Last edit: 7 years 9 months ago by nordmograph.
The following user(s) said Thank You: yourcon

Please Log in or Create an account to join the conversation.

More
7 years 9 months ago #34044 by yourcon
Replied by yourcon on topic datediff in the odometer
Many thanks for the great and fast support! :)

Please Log in or Create an account to join the conversation.

Time to create page: 0.314 seconds
Powered by Kunena Forum
Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.