Zen Cart Logo
Forums / General Questions / change time stamps

change time stamps

Locked

Views: 1,744

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
21 Jul 2009, 8:26 PM
#1
spid3r1987 avatar

spid3r1987

Zen Follower

Join Date:
Jul 2009
Posts:
497
Plugin Contributions:
0

change time stamps

Tue, 21 Jul 2009 15:18:53 -0500GMT [

im not at -0500
im london gmt
how do i change this??
also when i add products. i set the date added to 21/07/2009
but the product states
This product was added to our catalog on Tuesday 30 November, 1999

WHAAA?? i wasn't even online then lol!

21 Jul 2009, 10:02 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: change time stamps

spid3r1987:

Tue, 21 Jul 2009 15:18:53 -0500GMT [

im not at -0500
im london gmt
If you're referring to the date/time information in your admin menu bar, that comes directly from the server hosting your website. That's its clock detail.

spid3r1987:

how do i change this??You're not meant to. However, if it's a problem, there is a Time Zone Offset addon which you could experiment with if you're feeling lucky.

spid3r1987:

also when i add products. i set the date added to 21/07/2009
but the product states
This product was added to our catalog on Tuesday 30 November, 1999
Since the current version of the Zen Cart UI doesn't offer the option of setting the date-added manually, I must assume that you're making such edits manually using something like phpMyAdmin.
When making raw database edits, it's VERY important that you follow the same formatting conventions as the server itself uses. In the case of MySQL, proper date/time notation follows a specific format. For dates, it's YYYY-MM-DD.
Since you've entered the date in the wrong format, it's displaying a default fallback value when the data is retrieved.

21 Jul 2009, 10:33 PM
#3
spid3r1987 avatar

spid3r1987

Zen Follower

Join Date:
Jul 2009
Posts:
497
Plugin Contributions:
0

Re: change time stamps

products are added via easypopulate
text delimited file.
v_products_added
20/07/2009

etc..
i can explain more if required??
or try upload a template of the TxT file i use?

21 Jul 2009, 10:41 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: change time stamps

Perhaps you need to change your date format in your spreadsheet to MM/DD/YYYY in order for EasyPopulate to properly parse it?
I don't use EasyPopulate, so am probably not the one to answer questions related to it.

21 Jul 2009, 11:12 PM
#5
spid3r1987 avatar

spid3r1987

Zen Follower

Join Date:
Jul 2009
Posts:
497
Plugin Contributions:
0

Re: change time stamps

DrByte:

Perhaps you need to change your date format in your spreadsheet to MM/DD/YYYY in order for EasyPopulate to properly parse it?
I don't use EasyPopulate, so am probably not the one to answer questions related to it.

exactly that
im using UK date format
if i switch to US format its got the correct date on it.