Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sorting DATE_FORMAT_LONG as raw_date


evp

Recommended Posts

Hello all,

 

In article listing there are two columns, date and heading, both of which are sortable. The date is displayed as raw date in format YYYYMMDD, e.g. 2004-11-26

 

I would like to display the date as DATE_FORMAT_LONG e.g. Friday 26 November, 2004. I have no problem with that.

 

The problem is sorting itself. date_long sorts alphabetically which of course doesn't make much sense. I would like the date to be displayed as long-date but sort as raw date.

 

Can anybody help?

/e

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...