Error when trying to create an object DateTime in PHP

Question

Today I got a project written in PHP. There's an error when I try to show a date in a table data set. This is the statement that generates the error:

$data = new DateTime($registro["previsao de entrega"];

The error message is this:

Fatal error: Uncaught exception 'Exception' with message 'DateTime::__construct() Failed to parse time string (2 dez 2011 16:00) at position 0 (2): Unexpected character' in C:\www\fluxo_producao\Telas\TelaFluxoProducao.php:941 Stack trace: #0 C:\www\fluxo_producao\Telas\TelaFluxoProducao.php(941): DateTime->__construct('2 dez 2011 16:0...') #1 {main} thrown in C:\www\fluxo_producao\Telas\TelaFluxoProducao.php on line 941

What I discovered by myself was that if I change the parameter manually to "12 Dec 2006" for example, the function works. But the date the variable is passing is "12 Dez 2006" (Brazilian format, by the way, I'm Brazilian ^_^), and i found too that the default timezone in the server is "America/Sao_Paulo"... What do I have to change in the function or parameters to make it convert the format specified?

please output the value of $registro["previsao de entrega"] — silly
– silly, Commented Apr 5, 2012 at 14:25
what do u mean with output? do u actually wants to know the value? it's "12 Dez 2006" (without quotes) ;) — Giordano Giuliano
– Giordano Giuliano, Commented Apr 5, 2012 at 14:28

472084 · Accepted Answer · 2012-04-05 14:24:33Z

1

It needs to have a closing curly bracket on the end?

$data = new DateTime($registro["previsao de entrega"]);

If this is just a typo it could be the value of $registro["previsao de entrega"] is incorrect, what is it?

You can see allowed value formats here: http://www.php.net/manual/en/datetime.formats.date.php

It will only accept English month values, eg, Dec will work but Dez will not.

answered Apr 5, 2012 at 14:24

472084

17.9k10 gold badges67 silver badges82 bronze badges

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

4 Comments

Giordano Giuliano Over a year ago

Well, the variable $registro["previsao de entrega"] is how I access the value returned from a database...

Giordano Giuliano Over a year ago

Hummm... I see... But i'ts Dec because PHP is converting it to my timezone format... =/ What do i do?

472084 Over a year ago

setlocale(LC_TIME, 'pt_BR');

Giordano Giuliano Over a year ago

This is one of the problems i found... my default locale already is 'pt_BR'... What i figured is that PHP is retrieving the date from the database in the format 'YYYY-MM-DD HH:MM" and is setting the variable automatically to the pt-bR format =/ Any ideas?

DaveRandom · Accepted Answer · 2012-04-05 14:29:14Z

0

Verify that you have set your server to the correct time locale:

setlocale(LC_TIME, 'pt_BR');

This is required for strftime() and AFAIK all the date/time related functions and the DateTime class use the same library which will require/respect this setting.

answered Apr 5, 2012 at 14:29

DaveRandom

88.8k11 gold badges159 silver badges174 bronze badges

16 Comments

Giordano Giuliano Over a year ago

This is exactly what I was afraid to do... because the original code is not mine... and if i change that property it would cause impact in date conversion on another peaces of code... =/ Is this the only way?

Giordano Giuliano Over a year ago

Haha... i'm gonna do that... hope i don't get too much impact in the rest of the code... Just give me a clue... Where's the best place to put this setting? First of all code?

DaveRandom Over a year ago

Well you could set it before you execute this specific code, then set it back afterwards?

DaveRandom Over a year ago

I'm afraid you're probably stuck with str_replace(array('Dez', ...), array('Dec', ...), $str)

DaveRandom Over a year ago

Maybe this will help you?

|

Collectives™ on Stack Overflow

Error when trying to create an object DateTime in PHP

2 Answers 2

4 Comments

16 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

16 Comments

Your Answer

Sign up or log in

Post as a guest