ARI Soft - Display date format in %d %b %Y %T:%f ?

Home

News

Forum

About Us

Demos

Products

F.A.Q.

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.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

Display date format in %d %b %Y %T:%f ?

(1 viewing) (1) Guest

Page: 1

TOPIC: Display date format in %d %b %Y %T:%f ?

Forum Tools

#46332

Display date format in %d %b %Y %T:%f ? 11 Years ago Karma: 0

Hello ARI-Soft

My DB-table is filled with date-time data like 2013-11-01 04:37:00 .
Is there a way to display the date - time format in 04:37:00 01-11-2013 ( like %d %b %Y %T:%f ) ?

I use this query:

Code:

SELECT tijd, waterhoogte, extreem, tijd_maan, maanfase FROM #__getijden WHERE tijd>=CURDATE()

on this page in the column 'datum'.
The ARI-tags are like this:

Code:

{arisqltable} {arisqltablecolumns} {arisqltablecolumn id="tijd" alias="Datum" width="20%" className="idg"}

Regards,
Jan

janthuis

The administrator has disabled public write access.

#46334

Re:Display date format in %d %b %Y %T:%f ? 11 Years ago	Karma: 760
Hello, See DATE_FORMAT MySQL function. Regards, ARI Soft

admin

The administrator has disabled public write access.

#46378

Re:Display date format in %d %b %Y %T:%f ? 10 Years, 12 Months ago Karma: 0

Many thanks for your link, it did bring me to the right point of view.
For now this is my code and it works fine:

Code:

 {arisqltablequery} SELECT date_format(tijd,'%d-%m-%Y - %H:%i:%s') AS Datum, waterhoogte, extreem, maanfase, date_format(tijd_maan,'%d-%m-%Y - %H:%i:%s') AS Maantijd FROM #__getijden WHERE tijd >=CURDATE() {/arisqltablequery}

Kind regards,
Jan

janthuis

The administrator has disabled public write access.

#48109