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?

Show formatted date from millisecond (long)
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Show formatted date from millisecond (long)
#52108
Show formatted date from millisecond (long) 9 Years, 4 Months ago Karma: 0
Hi,

I would like to show the formatted date from millisecond column (start_time) as below.

SELECT
id,
deviceId,
jobOwnner,
DATE_FORMAT(FROM_UNIXTIME(start_time/1000), '%d/%m/%y'),
FROM_UNIXTIME(start_time/1000)
FROM
JobLog;

I had tested this with Ari DataTable and it doesn't show any data in the formatted date column. Any thing I had don't wrong with the SQL? It work with MySQL client.


Thanks,
Dennis
The administrator has disabled public write access.
 
#52109
Re:Show formatted date from millisecond (long) 9 Years, 4 Months ago Karma: 746
Hello,

Could you provide a link to a page where we can see the problem and send screenshot(s) of module settings page by email?

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1