php time()

[paddy_fields]

Hi there,

 

I have dates saved in my database in utc format ie- 20100901 (yyyymmdd) for sorting purposes. Currently when I display them I use substr to grab the year, month and day. I was wondering if it's possible to use the date() function to manipulate the data into something like '01 September 2010'. I understand how to format with date(), such as D d Y etc.. but is it possible to apply this to my utc data?

 

Cheers!

paddyfields. 

[Pikachu2000]

You should really store them in the proper (2010-09-16) format to begin with, then you'd be able to format them however you need using MySQL's DATE_FORMAT() function. Currently, you'll need to use a clunky mess like this:

$date = date('d F, Y', strtotime(~your properly formatted string here~))

[paddy_fields]

Thank you.

 

I was storing them in utc so I could sort by date.. but clearly what you've said would sort as well. I'll store them in the correct format from now on.

 

Many Thanks.

[Pikachu2000]

To clarify, they should be stored in the proper field type as well, which would be either DATETIME or DATE, then you can make use of all of the date and time manipulation features native to MySQL.

[paddy_fields]

Noted.

 

I've updated that as well - working perfectly.