Parsing datetime from MySQL

Parsing datetime from MySQL

El Forum
Guest

04-11-2010, 06:15 PM

[eluser]lenwood[/eluser]
I'm working to create a full featured blog with CI. I'm storing the published date & time in MySQL in the 'datetime' format. I'd like to separate the date and time within that string so that they can be used independently. I've read through the user guide and several tutorials as well, and this isn't coming together for me.

On most pages I'd like to show just the date. On the pages where I do include the time, I'll want it separate so that it can be formatted differently.

Can anyone help?

Messages In This Thread

Parsing datetime from MySQL - by El Forum - 04-11-2010, 06:15 PM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 12:46 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 12:55 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 01:02 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 07:23 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 07:30 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 07:34 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 10:01 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 10:19 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 04:59 PM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 05:12 PM

Parsing datetime from MySQL - by El Forum - 04-13-2010, 12:14 AM