Welcome, Guest
Username: Password: Remember me

TOPIC: [ADDED] Dates.. and GMT?

[ADDED] Dates.. and GMT? 05 Feb 2012 00:19 #1174

  • iconvisual
  • iconvisual's Avatar
  • Offline
  • Senior Member
  • Keen Joomla! 1.7 Developer
  • Posts: 53
  • Thank you received: 5
  • Karma: 1
Hi All,

Having an issue with Dates.

Starting from the 'raw data', my Table has a field called property_purchasedate and it is INT(11).

This is from a legacy database as a Unix Timestamp field, for example 1211292000 which translates to 2008-05-20 GMT, and in local time is 2008-05-21 (GMT + 10).

So, in my j-Cook Table I have a field property_purchasedate which is a Date field.Set to Inherit. All good so far.

So when I display my property_purchasedate in my FrontEnd Layout with the Date field I get 2008-05-20. Which is obviously GMT.

How can I change the display of the Date field according to my Local Time (i.e. GMT+10)?

Any pointers, advice, suggestions much appreciated.

Thank you kindly,

Edward.
Keen Joomla! and PHP/MySQL developer. Excited about J-Cook.
The administrator has disabled public write access.

Dates.. and GMT? 07 Feb 2012 13:10 #1184

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 985
  • Karma: 140
Date functionalities are not available yet.

Means that you have to write little bit.

I move the topic in 'New functionalities' and will develop this as soon as possible.

Stay in touch.
Coding is now a piece of cake
The administrator has disabled public write access.

Re: Dates.. and GMT? 27 Jun 2012 08:17 #2699

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 985
  • Karma: 140
Try with a timestamp format available now.
Coding is now a piece of cake
The administrator has disabled public write access.
The following user(s) said Thank You: edwardcox
Time to create page: 0.120 seconds

Get Started