Date Product Added

[Eagle75au]

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.

[TheOracle]

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.