R – Codeigniter: return datetime from db formatted

codeigniterdatetimeformatformatting

I'd like to format a datetime entry stored in a SQL db in a friendly format.

I'm just returning a simple query as a row(date)…

Is there a quick/easy way to do this?

I can post examples, if need be.

Right now the query is in a foreach loop:

<?php print $row['exp_date']?>

Best Answer

You can always use the php date function

Day of the week:

echo date("l", strtotime($row['exp_date'])); // monday

More complex sample:

echo date("l jS \of F Y h:i:s A", strtotime($row['exp_date'])); // Monday 8th of August 2005 03:12:46 PM

Related Solutions

C# – How to calculate someone’s age based on a DateTime type birthday

An easy to understand and simple solution.

// Save today's date.
var today = DateTime.Today;

// Calculate the age.
var age = today.Year - birthdate.Year;

// Go back to the year in which the person was born in case of a leap year
if (birthdate.Date > today.AddYears(-age)) age--;

However, this assumes you are looking for the western idea of the age and not using East Asian reckoning.

Sql – How to return only the Date from a SQL Server DateTime datatype

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date))

for example

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

gives me

2008-09-22 00:00:00.000

Pros:

No varchar<->datetime conversions required
No need to think about locale

Best Answer

Related Solutions

C# – How to calculate someone’s age based on a DateTime type birthday

Sql – How to return only the Date from a SQL Server DateTime datatype

Related Topic