4 replies to this topic

[dreamscape]

I know alot of people here run USA based stores, so I thought I'd post this. It may have been posted before, but I really can't remember so here it is.

Default OSC returns the long date format as "Wednesday 16 July, 2003". That format is a little awkward for us USA store owners. The correct USA format for that would be "Wednesday July 16, 2003"

how to change this? open includes/languages/english.php and at the top, change:

define('DATE_FORMAT_LONG', '%A %d %B, %Y'); // this is used for strftime()

to:

define('DATE_FORMAT_LONG', '%A %B %d, %Y'); // this is used for strftime()

[Ajeh]

Thanks, Josh ... I am not the best on fooling with dates and had someone asking on that one. Appreciate the tip greatly!

[BirdBrain]

For a chart of ALL of the variable symbols used by MYSQL in the DATE_FUNCTION see this thread:
[/url]http://forums.oscommerce.com/viewtopic.php?p=162447#162447

Many thanks to Kevin Yank for his book, "Build Your Own Database Driven Website"

[Ajeh]

Very handy! Thanks, Kim ...

[BirdBrain]

You're welcome! There are all kinds of handy-dandy charts in the appendix.