PHP DateTime conversion

Question

I currently have stored DateTime in the database as follows 20130208110000 so I need to break it into 2 parts which is date in this format 08/02/2013 and time in this format 11:00 AM, which function does this effectively?

This is the function I used to join both date and time together

$startMonth = $this->_getParam('starts_month_day_year');
$startTime = $this->_getParam('starts_time');
date("YmdHis",strtotime($startMonth.$startTime));

why dont use store the date in one of the db date\time field types and make life a lot esier — user557846
– user557846, Commented Feb 8, 2013 at 2:48
@Dagon hi its too late for modification as i planning to do changes on later time — Saraswathi Apavoo
– Saraswathi Apavoo, Commented Feb 8, 2013 at 2:50
its never to late to do things properly, you could convert then with a script in about 10 minutes — user557846
– user557846, Commented Feb 8, 2013 at 2:51

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

<?php
      $originalDate = "20130208110000";
      $newDate = date("d-m-Y g:i A", strtotime($originalDate));
      echo $newDate;  //08-02-2013 11:00 AM
?>

where,

g :12-hour format of an hour without leading zeros [0 through 12]

i :Minutes with leading zeros [00 through 59]

A:Uppercase Ante meridiem and Post meridiem [AM or PM]

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Feb 8, 2013 at 2:54

Bhushan Firake

9,4825 gold badges47 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jonah Bishop · Accepted Answer · 2013-02-08 02:51:45Z

1

What would be wrong with just using what you're already doing?

$myDate = "20130208110000";
date("d/m/Y", strtotime($myDate)); // Date, e.g. 08/02/2013
date("h:i A", strtotime($myDate)); // Time, e.g. 11:00 AM

answered Feb 8, 2013 at 2:51

Jonah Bishop

12.7k6 gold badges52 silver badges77 bronze badges

Collectives™ on Stack Overflow

PHP DateTime conversion

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related