Zen Cart Logo
Forums / General Questions / Date Product Added

Date Product Added

Locked

Views: 1,112

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
27 May 2007, 12:33 PM
#1
eagle75au avatar

eagle75au

New Zenner

Join Date:
May 2007
Posts:
64
Plugin Contributions:
0

Date Product Added

Im having problems with the site showing the date for products added as nothing like what they should be

i add a product today and it shows dates like '1969' so on...

the site date and time is all set fine...

is there anyway i can rectify this without turning it off.

27 May 2007, 12:56 PM
#2
theoracle avatar

theoracle

Suspended

Join Date:
Aug 2004
Posts:
3,180
Plugin Contributions:
1

Re: Date Product Added

Does the date and time shows correctly under your TABLE_PRODUCTS table from your phpmyadmin console ? If so, I believe the field is in TIMESTAMP. Some servers returns bad results with this field - for an unknown reason. I fixed this up by renaming the TIMESTAMP file into two seperated fields with a VARCHAR field. Then, I used the date PHP module to inject the proper date and time.

Since then, it returns the right results. Of course, this technic required some time to rename all the TIMESTAMP fields into the two seperated fields in all affected PHP files. :wink2: