Formatting SQL Server time(7) using PHP date()

Question

In my SQL Server database I have a time field stored as time(7). I have been trying to print this in PHP using echo but I wouldn't work, so I used this code

"ReturnDatesAsStrings" =>1

and it returned

08:35:00.0000000

And for the past hour I've been trying to format it into 08:35am using the date() function but have had no luck. Any clues?

Álvaro González · Accepted Answer · 2012-04-19 15:35:25Z

2

If you disable ReturnDatesAsStrings what you get is a DateTime object. Obviously, a object cannot be printed with a plain echo, but you have a proper date and all you have to do is to call the format() method on it. Using strings as intermediate format when PHP can do it for you is a bigger hassle.

answered Apr 19, 2012 at 15:35

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

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

2 Comments

aelsheikh Over a year ago

How would I go about doing it your way?

aelsheikh Over a year ago

Nvm, figured it out. Works a charm!

webbiedave · Accepted Answer · 2012-04-19 15:10:52Z

1

echo date('H:ia', strtotime('08:35:00.0000000')); // 08:35am

or, better, use the DateTime class:

$date = new DateTime('08:35:00.0000000');
echo $date->format('H:ia'); // 08:35am

answered Apr 19, 2012 at 15:10

webbiedave

49k8 gold badges92 silver badges104 bronze badges

Comments

McGarnagle · Accepted Answer · 2012-04-21 08:58:28Z

1

Try this:

date_format( strtotime($datetime_field_in_db), 'g:i A') );

edited Apr 21, 2012 at 8:58

McGarnagle

103k31 gold badges235 silver badges264 bronze badges

answered Apr 19, 2012 at 15:12

Churk

4,6475 gold badges25 silver badges40 bronze badges

Collectives™ on Stack Overflow

Formatting SQL Server time(7) using PHP date()

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related